Select the column (I used E).

And with E1 the active cell...

Format|conditional formatting
formula is: =E1=""
choose a nice format



Ross wrote:

How do I usse conditional formatting to tell all the cells in a particular
column to change one color if there is something in a cell, and another if
it is blank?

The column in question is the "Date Closed" column and I want the blank
cells to stand out from the rest.
Thanks
Ross

--

Dave Peterson