Conditional formatting: format when range of cells are blank

C

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
 
G

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
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
Top