Hi Karenobrn,

You can also use Conditional Formatting to colour a cell if it's empty. A formula you might use to colour a cell depending on the
value in A1 is =A1="" or =Trim(A1)="".

--
Cheers
macropod
[MVP - Microsoft Word]


"Karenobrn" wrote in message ...
I would like to format a column so that if no data has been entered in a cell
in that column then the cell would be colored or marked somehow. Is this
possible? I have tried Conditional Formatting but it only colors the cell if
there is data in that cell... I want to do the opposite.

Thanks
Karen