Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formatting of a Conditional Statement
I want to be able to change the background of a cell colour if a second
condition is met - but for the background to remain unchanged if the first condition is met. So in the formula below, the background would be yellow if the 'c2' condition is satisfied. =if(c10,c1,c2) My actual formulae are much more complex but if someone can point me in the right direction in terms of principles that would be great |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with if statement | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING OR AN 'IF' STATEMENT? | Excel Discussion (Misc queries) | |||
Can I use an if statement within the conditional formatting tool? | Excel Discussion (Misc queries) | |||
If Statement/Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting based on if statement. | Excel Worksheet Functions |