Painting blank cells

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
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
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Painting equal cells 2
Reverse string on multiply cells 3
Stop zero on cell 6
Twin cells 5
Passing data to fix cell 4
Ignoring empty cells 6
Conditional Formatting 3
Activate cell in protection mode 4

Back
Top