Conditional formatting - Blank

K

kalz

Hi, I like to highlight range of cells if they are blank, how to set this up
in the function?
 
M

MarkN

hi Kalz,

Use conditional formatting.
-Highlight the range.
-From the Format menu, select Conditional formatting.
-Change 'cell value is' to 'formula is' and type =ISBLANK(C2), use the cell
reference at the upper left corner of your range.
-Click on the Format... button and choose the format required.
-Click Ok to close dialog boxes and you should be sorted.
 
Top