"colorif" function

  • Thread starter Thread starter Dave
  • Start date Start date
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.
 
Dave,

Try using Conditional Formatting from the Format menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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
 
Back
Top