Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting - Blank
Hi, I like to highlight range of cells if they are blank, how to set this up
in the function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting - Blank
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |