colors

[antonov]

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?

[Tom Ogilvy]

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" <antonov@dds.nl> wrote in message
news:xGjof.6595$Cn4.3219@tornado.fastwebnet.it...
> 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?
>
>

[antonov]

Thanks Tom, it's exactely what I was looking for....
"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:eJj1yFbAGHA.832@tk2msftngp13.phx.gbl...
> 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" <antonov@dds.nl> wrote in message
> news:xGjof.6595$Cn4.3219@tornado.fastwebnet.it...
>> 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?
>>
>>
>
>