conditional formatting

F

frank

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

Peo Sjoblom

Use formula is and

=other_cell=""

will format if it is blank

=other_cell<>""

will format if it is not blank

Regards,

Peo Sjoblom
 
Top