Dave,
Try using Conditional Formatting from the Format menu.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Dave" wrote in message
...
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.