"colorif" function

D

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.
 
C

Chip Pearson

Dave,

Try using Conditional Formatting from the Format menu.


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

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
 
Top