Conditional formatting/non blank cells

  • Thread starter Thread starter Caroline
  • Start date Start date
C

Caroline

Hello,
(Excel 2007) I am trying to format a cell based on another cell being "non
blank". I thought the non blank formula was "<>" but it's not working, e.g.
=$E$2="<>"
This =$E$2="" works for blank cells but I need it to be "non blank".
Thank you for your help,
Caroline
 
Caroline said:
Hello,
(Excel 2007) I am trying to format a cell based on another cell being "non
blank". I thought the non blank formula was "<>" but it's not working, e.g.
=$E$2="<>"
This =$E$2="" works for blank cells but I need it to be "non blank".
Thank you for your help,
Caroline
Click to expand...


=$E$2<>""
 
Use
=$E$2<>""

Two double quotes without anything in between to represent blank.
Or use =ISBLANK($E$2)

Be careful with absolute references if you are going to use this over
multiple cells.
 
NOT ISBLANK($E$2)


Sheeloo said:
Use
=$E$2<>""

Two double quotes without anything in between to represent blank.
Or use =ISBLANK($E$2)

Be careful with absolute references if you are going to use this over
multiple cells.
Click to expand...
 
Back
Top