Use formula is and

=other_cell=""

will format if it is blank

=other_cell<""

will format if it is not blank

Regards,

Peo Sjoblom

"frank" wrote:

i want to use conditional formatting. i would like a
cell to be shaded dependant on whether another cell is
blank or not.