Conditional formatting: format when range of cells are blank
 

When using the conditional formatting is there a way to determine if a range
of cells are empty? Is there a way to determine if a named range is empty?
As well, is there a way to use AND/OR when using conditional formatting?

Chad

Conditional formatting: format when range of cells are blank
 

a range of cells are empty
FORMULA IS: =LEN($D1)<0

use AND/OR when using conditional formatting
FORMULA IS: =AND($F11,$F1<4)
FORMULA IS: =OR($G1=2,$G1=4)

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"ChadBellan" wrote:

When using the conditional formatting is there a way to determine if a range
of cells are empty? Is there a way to determine if a named range is empty?
As well, is there a way to use AND/OR when using conditional formatting?

Chad