Book11 | |||
---|---|---|---|
M | |||
2 | |||
3 | |||
4 | off | ||
5 | m-off-1 | ||
6 | |||
7 | |||
8 | off | ||
9 | m-off-1 | ||
10 | |||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
M2:M17 | Expression | =ISNUMBER(SEARCH("OFF",$M2)) | text | YES |
23 12 01.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Hdr1 | Hdr2 | Hdr3 | Hdr4 | Hdr5 | Hdr6 | Hdr7 | Hdr8 | Hdr9 | Hdr10 | Hdr11 | Hdr12 | Hdr13 | ||
2 | data | data | data | data | data | data | data | data | data | data | data | data | OFF | ||
3 | data | data | data | data | data | data | data | data | data | data | data | data | ON | ||
4 | data | data | data | data | data | data | data | data | data | data | data | data | Neither | ||
5 | data | data | data | data | data | data | data | data | data | data | data | data | |||
6 | data | data | data | data | data | data | data | data | data | data | data | data | OFF | ||
7 | data | data | data | data | data | data | data | data | data | data | data | data | new office chair | ||
CF OFF |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2:M7 | Expression | =SEARCH("OFF",$M2) | text | NO |