Conditional Formatting - Highlight blank cells

[mattstan2012]

Hi

I want to highlight (in light grey as below) cells that are empty. I've used conditional formatting to highlight only cells that contain blanks. This works where the cells are truly blank, but some have a formula in them (such as in column BG and BT). How do I get it to recognise that, for example, column BT has blank cells even though the cells in not srtictly "empty" as it has a formula in it? Same as the few in column BG, BK, BO etc. Any why, for example, does it recognise that column BR is blank (whilst containing a formula) but it doesn't recognise column BT in the same way (blank, but containing a formula)

 

[mattstan2012]

@SanjayGMusafir

Here are the rules and orders. I can't see anything here that would cause any override:

 

[Fluff]

Have you checked what I said in post#5?

 

[Fluff]

Looking at the conditions he has given that has to be the solution...

No it does not. See post#5

 

[mattstan2012]

These arfe all the rules that are applyijng - I can't see anything hat woul particularly be over-riding anything else?

 

[Fluff]

Have you checked what I said in post#5?

 

[mattstan2012]

I'm really sorry @Fluff but I wasn't sure what post #5 was instructing me to do/try/check?

 

[Fluff]

On the cells that are not getting formatted, the formula is probably not returning "", but a number (probably 0). So check what the formula is actually returning, which you can do use the Evaluate Formula button on the formula tab.

 

[mattstan2012]

Have you checked what I said in post#5?

Readijng it again @Fluff I think I know what you were after, so added a CF for a cell value of 0 AND IT HAS WORKED !!!!!!! Thank you so much. And also, thamnk you to @SanjayGMusafir for trying to help (even though you may have been barking up thte wrong tree) :O)


a

 

[Fluff]

Glad we could help & thanks for the feedback.