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
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
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
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
Thanks a lot!
"Roger Govier" wrote:
> 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
>
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks