Simple - you use the same formula (ie =A1="" or =Trim(A1)="") while using Format|Conditional Formatting with cell A3 selected.

--
Cheers
macropod
[MVP - Microsoft Word]


"FIRE GIRL" wrote in message ...
How would I adjust this formula to color the contents of cell A1 if cell A3
is left empty?? (instead of coloring the same cell that is empty?)

"macropod" wrote:

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