Painting blank cells

[Amnon Wilensky]

Hi,
How can I use Conditional format to paint all empty cells on a certain range
(say A124) with yellow color?

Thanks,
Amnon

 

[Mike H]

hi,

Click in A1 the drag to select A1 - D24 then
Format|conditional format|Formula is
=ISBLANK(A1)
Pick your colour and click OK.

Mike

 

[David Biddulph]

CF/ Cell Value Is/ =""
and format choosing your pattern colour

 

[Amnon Wilensky]

Thanks,
Amnon

hi,

Click in A1 the drag to select A1 - D24 then
Format|conditional format|Formula is
=ISBLANK(A1)
Pick your colour and click OK.

Mike

 

[Amnon Wilensky]

Thanks,
Amnon

CF/ Cell Value Is/ =""
and format choosing your pattern colour