Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I want a cell to be colored if E9,G9,&J9 all have yes entered in, but the
formula I am using does not color the cell. ="if(and($E$9=""yes"",$G$9=""yes,$J$9=yes)" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting Help | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |