Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overlapping conditional formats
I'm currently working on a spreadsheet where I have 2 cells in a row where
the backround turns grey based on a cell's value. I also want to have the text in that row turn green based on the value of another cell. When I highlight the row to set the text condition, the conditions for the 2 cells come up. If I add a 3rd condition, the 1st 2 conditions apply to the whole row. If I delete the 2 conditions & add the text condition, I lose the formatting on my 2 cells. Any suggestions? Thanks, -- Vanessa M Bailey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formats, how to scroll and view all formats? | Excel Worksheet Functions | |||
Pivot tables and conditional formatting and overlapping | Excel Discussion (Misc queries) | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
paste conditional formats as formats | Excel Discussion (Misc queries) | |||
More than three conditional formats? | Excel Discussion (Misc queries) |