excel building

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel 2010 - building a macro ( if function?) | Excel forum

resolvedResolved · Urgent Priority · Version 2010

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

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


 

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips


Server loaded in 0.08 secs.