| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting & Dynamic Range | Excel Worksheet Functions | |||
| Cell color change without using conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting a full row triggered by a single cell | Excel Worksheet Functions | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
