Patti,

You don't need a macro. You can accomplish what you want using
the Conditional Formatting tool on the Format menu.


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


"Patti F" wrote in message
...
I have little macro experience and I need to change the color
of the cell
when a condition is met. I would appreciate any help.