Geek Girl 007
Board Regular
- Joined
- Mar 12, 2022
- Messages
- 127
- Office Version
- 2021
- Platform
- Windows
Hi jtakw,
It would seem like you're my saviour at the moment.
How do I set this? would it make a difference that the cell with PH (stands for Public holiday) might have different text in it?
Book3.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | |||
14 | PH | ||||||||
15 | |||||||||
16 | |||||||||
17 | |||||||||
18 | PH | ||||||||
Sheet1053 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
E14:J18 | Expression | =$K14="PH" | text | NO |