Excel Conditional Formatting

[NilDesper]

I haven't done this for many years and the current excel does not operate as I seem to remember.

I want to highlight a cell if another cell has an entry. I have tried =D6 <> "" and =D6 <> () but neither is accepted or the application doesn't happen.

Any help appreciated.

ND

[Itsallaguess]

I haven't done this for many years and the current excel does not operate as I seem to remember.

I want to highlight a cell if another cell has an entry. I have tried =D6 <> "" and =D6 <> () but neither is accepted or the application doesn't happen.

Try -

=NOT(ISBLANK($B3))

where $B3 is the cell that might be blank, or might have something in it.

Tested and working on Office 2007.

Cheers,

Itsallaguess

[Watis]

I haven't done this for many years and the current excel does not operate as I seem to remember.

I want to highlight a cell if another cell has an entry. I have tried =D6 <> "" and =D6 <> () but neither is accepted or the application doesn't happen.

Any help appreciated.

ND

Or, if you want to do something with the information:

Something of the form: =IF(B7<>"",<action if B7 is not blank>,<action if B7 is blank>) should do the trick.

HTH,

Watis