Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Condtional formatting
Hello everyone,
I'm looking for a condtional formatting formula based on 2 conditions. The conditions are based on a text that are in 2 different cells in the same row. For example: if A1 contains "Start" and A2 contains "Operation" I want row 1 green; if if A1 contains "Stop" and A2 contains "Operation" I want row 1 red. A1 and A2 contain drop down list. All other combinations should give the rows blue. This last condition is a normal cell format. At least 15 columns in the speadsheet. Has someone an idea solve the problem? Thank you for any suggestion |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |