Cell Highlighting

P

perezianda

How can I have a cell automatically hightlight when any data is entered in
that cell. Conditional formatting not working for this.
 
G

Gord Dibben

Select the cell, say A1

Format>CF>Formula is: =A1<>""

Pick a color and OK.


Gord Dibben MS Excel MVP
 
R

Ronster

perezianda said:
How can I have a cell automatically hightlight when any data is entered in
that cell. Conditional formatting not working for this.
Click to expand...

This works:

Formula Is =CODE(A1)>0
 
H

hot dogs

Set the font, colour, etc of the cell when it will have data entered. Then go
to conditional formatting, set 'formula is' =A1="" then set the format to
automatic with no fill. where A1 is the cell.
 
Top