How to format cell using Blank and Conditional Formatting..

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

Tim Harding

I have a spreadhseet which has conditional formatting

so that if a cell is less than a target it goes red and if
higher goes green, however if the cell is blank how do I
get it to stay white....?

Thanks

Tim
 
Hi
use the following formulas in the conditional format dialog:
=(A1>value)*(A1<>"")

and
=(A1<value)*(A1<>"")
 
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

Conditional Formatting 1
conditional formatting update issue 5
Pre Condition Cells White when blank 2
Using NULL in shading cells 1
Excel Conditioning Formatting 3
Conditional formatting 2
Conditional Formating in Blank Cells 4
Conditional Formatting 4th Condition 3

Back
Top