| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| All colors in Office documents are grayscale, how do I see colors | Excel Discussion (Misc queries) | |||
| Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
| Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
| Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Linear Mode
