Conditional Formatting Across Multiple Cells

**TheLeafs** · 05-01-2009, 10:45 AM

Good day folks,

I have a range from E3:I3, and if any one of those cells are blank, I want the entire range to be highlighted in any colour. Is this possible?

Thank you,

**NBVC** · 05-01-2009, 10:49 AM

Select E3:I3 and go to Format|Conditional Formatting.

Select Formula Is from 1st dropdown and enter formula:

=COUNTBLANK($E$3:$I$3)>0

then click Format to choose your colours...

... go Leafs go... not this year!

**TheLeafs** · 05-28-2009, 09:48 AM

Worked great, thanks.

It's always next year...

**NBVC** · 05-28-2009, 09:51 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save