"colorif" function

[Dave]

Does anyone have a macro that works as a "colorif"
function would? For example, color cell green if = 4,
color cell yellow if = 3, color cell red if = 2.

 

[Chip Pearson]

Dave,

Try using Conditional Formatting from the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[sowetoddid]

It sounds like you could use "Conditional Formatting", which is unde
Format at the top of the screen. You put in your tests values exce
will color the cells accordingly