F frank Dec 2, 2004 #1 i want to use conditional formatting. i would like a cell to be shaded dependant on whether another cell is blank or not.
i want to use conditional formatting. i would like a cell to be shaded dependant on whether another cell is blank or not.
G Guest Dec 2, 2004 #2 Use formula is and =other_cell="" will format if it is blank =other_cell<>"" will format if it is not blank Regards, 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
