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.
--
Hope this helps,
MarkN


"kalz" wrote:

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