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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>>
>
>