ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi all,
I have a file (link also included), where I’m trying to conditionally format a column to show as a blank white cell if the formula result is blank (“”). However, my other red conditional format for any values over a certain value (greater than or equal to 25,000) seems to override it. i.e. All of the cells J53:J158 should appear as blank. I tried this =LEN($J$4:$J$158)=0, but doesn’t seem to work.
Steps - WORKING.xlsx
Any help appreciated!
Thanks in advance!
I have a file (link also included), where I’m trying to conditionally format a column to show as a blank white cell if the formula result is blank (“”). However, my other red conditional format for any values over a certain value (greater than or equal to 25,000) seems to override it. i.e. All of the cells J53:J158 should appear as blank. I tried this =LEN($J$4:$J$158)=0, but doesn’t seem to work.
Steps - WORKING.xlsx
Any help appreciated!
Thanks in advance!