ExcelBanter - Conditional formatting depending a range of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional formatting depending a range of cell (https://www.excelbanter.com/excel-worksheet-functions/53003-conditional-formatting-depending-range-cell.html)

Marisa

Conditional formatting depending a range of cell

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

Roger Govier

Conditional formatting depending a range of cell

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

Marisa

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

All times are GMT +1. The time now is 04:46 PM.