Painting blank cells

A

Amnon Wilensky

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

Thanks,
Amnon
 
M

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
 
A

Amnon Wilensky

Thanks,
Amnon
Mike H said:
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
Click to expand...
 
Top