Conditional formatting: format when range of cells are blank

[ChadBellan]

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

 

[Gary Brown]

a range of cells are empty
FORMULA IS: =AND($F1>1,$F1<4)
FORMULA IS: =OR($G1=2,$G1=4)

--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.