Macro to change text color

[Erin]

Is there a way to create a macro that will change the
color of the text? For example, all numbers in a grid that
are 120 and over I need to be green, and all numbers 80
and under I need to be red. Is there any way to do this?

 

[Judy Freed]

You dont need a macro. Conditional Formatting will accomplish this. Select
your cells, then select Format, Conditional Formatting. Set your conditions
and determine what format to apply to each condition. This might help:

http://www.uncc.edu/sysdev/HowTos/Excel/Using Conditional Formatting with Numeric Values.htm

Judy

 

[Erin]

THANK YOU THANK YOU THANK YOU. You have no idea how much
this helps and how much easier you just made my life!!!