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)

 

[SanjayGMusafir]

To check if cell is totally blank
=ISBLANK(BT1)

To Check if cell returns Blank Value
=BT1=""

 

[Fluff]

What is the formula in col BT & what is the CF rule that you are using?

 

[mattstan2012]

What is the formula in col BT & what is the CF rule that you are using?

Hi Fluff - thanks for taking a look at this. The formula in col BT (col BT row 45 for example) is =IFERROR(BQ45*BS45,""). The CF rule I've used is to format the cell with a light grey fill if the "cell contains a blank value". However, the grey fill is not applied, because, I assume, of the formula. HOWEVER...... I have a similar formula in col BR which is =IFERROR(BQ45/BQ$55,"") and this cell DOES apply the CF rule and fills the cell with the light grey fill ???

 

[Fluff]

Thanks for that, I suspect that the formula is not returning ", but possibly 0 & you have cells with 0 to show ""

 

[mattstan2012]

To check if cell is totally blank
=ISBLANK(BT1)

To Check if cell returns Blank Value
=BT1=""

Hi Sanjay - Both result in a return of "False", but I KNOW the cell is not blank as it has a formula in it. in the column between "Calls" and "Ave", I have a formula, for example, =IFERROR(Y63/Y73,""), but the CF of a light grey fill if the cell is blank has applied to these cells, but I have a similar formula in the column TTL - =IFERROR(Y63*AA63,"") - but the CF doesn't apply itself to these cells. I'm trying to understand why and what is the difference between these two so that I can make sure the fill DOES apply

 

[SanjayGMusafir]

but I KNOW the cell is not blank as it has a formula in it

In that case it has Conditional Format has to be using formula

=CellAddress=""

Try again

 

[Fluff]

That is not true & you would have known that, if you had actually read what has been posted.

 

[SanjayGMusafir]

That is not true & you would have known that, if you had actually read what has been posted.

I read that that's why I said Try Again

At times person tends to use wrong cell address while using Conditional Format or testing. It's a common mistake...

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

 

[SanjayGMusafir]

@mattstan2012 another challenge could be some Conditional Format overriding.

In that case you have to check the order of rules on that particular range.