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.

"perezianda" wrote:

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