Highlight Range Until One Cell Has Data

I have a range of cells D6:G14 that I have highlight cells rules applied using the formula =ISBLANK(D6:G14).

How can I alter this so that if one of the cells has data then all of the cells have the highlight removed?

Thank you for your help

Try this for your CF condition instead:

=COUNTA($D$6:$G$14)=0

Hope this helps.

Pete

Perfect! Thanks Pete

You're welcome - thanks for the rep.

Pete