Conditional formatting depending a range of cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
conditional formatting update issue 5
Conditional Formatting 4
conditional format rage based on entries within range 7
Conditionally format a cell using a list of data defined in a rang 2
Excel Named Ranges and Conditional Format 3
VBA set thick borders around non empty cells in range 0
Excel Conditional Formatting Removal 7

Back
Top