How do I shade a cell if its blank?
 

I have alot of records in a Excel file. Some cells are blank and I wanted to
color those cells. How would I go about doing this?

How do I shade a cell if its blank?
 

Select the range or sheet, then do formatconditional formatting, select
cell value equal to and use ="", click the format button and select grey and
click OK twice


--
Regards,

Peo Sjoblom



"pokdbz" wrote in message
...
I have alot of records in a Excel file. Some cells are blank and I wanted
to
color those cells. How would I go about doing this?

How do I shade a cell if its blank?
 

How could I do this by making a Macro or writing it in VB. I have multiple
Excel files that I need to do this on.

"Peo Sjoblom" wrote:

Select the range or sheet, then do formatconditional formatting, select
cell value equal to and use ="", click the format button and select grey and
click OK twice


--
Regards,

Peo Sjoblom



"pokdbz" wrote in message
...
I have alot of records in a Excel file. Some cells are blank and I wanted
to
color those cells. How would I go about doing this?