ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/1095-conditional-formatting.html)

frank

conditional formatting

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

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

"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.

All times are GMT +1. The time now is 11:51 AM.