Conditional formatting/non blank cells

[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

 

[Gary''s Student]

=$E$2<>""

 

[Glenn]

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

=$E$2<>""

 

[Sheeloo]

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.

 

[Sheeloo]

NOT ISBLANK($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.