Conditional formatting depending a range of cell
Thanks a lot!
"Roger Govier" wrote:
Hi Marissa
One way
Select the cell requiredFormatConditional Formattinguse drop down for
Formula Is and type in white pane =COUNTA($A$1:$A$5)0
Choose Format required.
Regards
Roger Govier
Marisa wrote:
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
|