Conditional formatting depending a range of cell

M

Marisa

Dear all,
I need to change the format of a cell if any cell within the range A1:A5 is
non-blank or not empty. How can I do it?
Thanks a lot,
Marisa
 
R

Roger Govier

Hi Marissa

One way
Select the cell required>Format>Conditional Formatting>use drop down for
Formula Is and type in white pane =COUNTA($A$1:$A$5)>0
Choose Format required.

Regards

Roger Govier
 
M

Marisa

Thanks a lot!

Roger Govier said:
Hi Marissa

One way
Select the cell required>Format>Conditional Formatting>use drop down for
Formula Is and type in white pane =COUNTA($A$1:$A$5)>0
Choose Format required.

Regards

Roger Govier
Click to expand...
 
Top