Pre Condition Cells White when blank

  • Thread starter Thread starter Tim Harding
  • Start date Start date
T

Tim Harding

Using some conditional formatting on cells

however when a cell is blank is there any way to keep it
white

I am using conditional formatting so that when cell is
greater than target it goes Green and Lower = Red

however when blank it goes green.

Any advice?

Thanks

Tim
 
Yes, make the first condition equal to "", and set to no colour
 
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

Using NULL in shading cells 1
Conditional Formatting 1
conditional formatting update issue 5
How to format cell using Blank and Conditional Formatting.. 1
Conditional Formating in Blank Cells 4
Changing cell colors from a function command 3
Excel Conditioning Formatting 3
Conditional Formatting Blank =white.. but 4 conditions 3

Back
Top