Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010 - building a macro ( if function?)

Excel 2010 - building a macro ( if function?)

ResolvedVersion 2010

Thu 10 Nov 2011, 12:41 Delegate Sylvia said...

Sylvia has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course

Excel 2010 - building a macro ( if function?)

Hello. I would like to build a macro so that the font in a certain cell ( numbers) change colors when they reach certain levels. For example:

Lower than 75%: figure in green
- Between 75% and 150%: figure in orange
- Higher than 150%: figure in red

Thank you.

Sylvie

Fri 11 Nov 2011, 13:01 Trainer Anthony said...

RE: Excel 2010 - building a macro ( if function?)

Hi Sylva, thanks for your query. You should consider using conditional formatting to do this, it would be a much simpler solution to the problem than using a macro and code!

Hope this helps,

Anthony

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips

Excel 2010 - building a macro ( if function?)

Excel 2010 - building a macro ( if function?)

RE: Excel 2010 - building a macro ( if function?)

Excel articles

Excel tip:

Switch on smart tags – Excel 2007