If you have just one condition, you may use Format - Conditional formating
instead. It can handle complicated conditions, check the help file.

"Patti F" wrote:

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.