Conditional format using ISBLANK function, not disappearing when cell has data.

**ibabs** · 06-19-2013, 05:11 PM

Hello,
I am making some conditional formats for a document. One that I am trying to achieve is have a group of cells have a background color, but once the data has been added, the color go away.

This is what my conditional format looks like: =ISBLANK($A$1:$H$22) and chose the Green fill background. So, my understanding is, the cells should have a green background if they are blank, but go back to a standard format, once cells have data put in them.

Can someone tell me why this isn't working?

thanks
babs

**Melvinrobb** · 06-19-2013, 05:35 PM

The ISBLANK formula can only reference individual cells.
You need to use the formula "=isblank(a1)" . That way it looks at the individual cell and determines if it is blank.
Change the area that conditional formatting is applied to to "$A$1:$H$22", and you should be good to go.