ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   colors (https://www.excelbanter.com/excel-programming/348236-colors.html)

Antonov

colors
 
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

colors
 
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?





Antonov

colors
 
Thanks Tom, it's exactely what I was looking for....
"Tom Ogilvy" wrote in message
...
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?








All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com