DailyCaffeine
New Member
- Joined
- Feb 9, 2022
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Hello, I have a conditional format that only sometimes work.
I'm trying to make is to that whenever $J:$J says "Overdue", cells on a different sheet changes colours, otherwise it leaves the cells blank.
My two conditional formatting rules for them are
='Sample Sheet'!$J:$J="Overdue" turns it red
='Sample Sheet'!$J:$J<>"Overdue" leave it white
My problem is that it only sometimes work whenever I test it on the current excel I have but works if I make a new one. Is it because I have a lot of sheets on the one I'm working on or am I doing something wrong?
Thank you in advance
I'm trying to make is to that whenever $J:$J says "Overdue", cells on a different sheet changes colours, otherwise it leaves the cells blank.
My two conditional formatting rules for them are
='Sample Sheet'!$J:$J="Overdue" turns it red
='Sample Sheet'!$J:$J<>"Overdue" leave it white
My problem is that it only sometimes work whenever I test it on the current excel I have but works if I make a new one. Is it because I have a lot of sheets on the one I'm working on or am I doing something wrong?
Thank you in advance