Conditional format cells that appear blank ("")

[ollyhughes1982]

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!

 

[etaf]

I have changed the conditional format to use an AND()
=AND( J4 <> "", J4>2500)

its because a formula is in the cell, its not beeing seen as a "" by that conditional formatting setting
See dropbox for full excel sheet - BUT will only be there a few days

so I used a section in XL2BB for display here

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[ollyhughes1982]

I have changed the conditional format to use an AND()
=AND( J4 <> "", J4>2500)

its because a formula is in the cell, its not beeing seen as a "" by that conditional formatting setting
See dropbox for full excel sheet - BUT will only be there a few days

so I used a section in XL2BB for display here

Dropbox - File Deleted - Simplify your life

www.dropbox.com

Thanks! That’s great

 

[etaf]

you are welcome