Darren_workforce
Board Regular
- Joined
- Oct 13, 2022
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
Hello,
I am struggling with the formula needed to cause any cell with "off" to turn the text invisible. I've attempted
and I've tried using the custom number formatting (;;
but it isn't working.
This is for the entire sheet but Row 1 is not required as the data is setup in a table
Any help would be appreciated.
I am struggling with the formula needed to cause any cell with "off" to turn the text invisible. I've attempted
Excel Formula:
=$A$2="off"

This is for the entire sheet but Row 1 is not required as the data is setup in a table
Any help would be appreciated.