Have you considered conditional formatting?
Found in the menu structure Format=Conditional Formatting
See Debra Dalgleish's site:
http://www.contextures.com/tiptech.html
Look under C and conditional formatting
--
Regards,
Tom Ogilvy
"antonov" wrote in message
...
Is it possible to change color (or even color the cells if no color has
yet
been chosen) in cells (or rows) only if a certain cell has a (any) value?