Select the cell, say A1

FormatCFFormula is: =A1<""

Pick a color and OK.


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 15:18:01 -0700, perezianda
wrote:

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