noobsaibotcore
New Member
- Joined
- Oct 9, 2021
- Messages
- 7
- Office Version
- 2019
- Platform
- Windows
Hi all, need help with cell conditional highlight.
- If CELL B4 to B8 have the text "Y" or "N/A", CELL A1 to be highlighted in green.
- If any from CELL B4 to B8 is not "Y" or "N/A", CELL A1 to be highlighted in yellow.
- If any from CELL B4 to B8 is blank, CELL A1 have no highlight.
- If CELL B4 to B8 have the text "Y" or "N/A", CELL A1 to be highlighted in green.
- If any from CELL B4 to B8 is not "Y" or "N/A", CELL A1 to be highlighted in yellow.
- If any from CELL B4 to B8 is blank, CELL A1 have no highlight.