| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shade Cell if Sum is 0 | Excel Worksheet Functions | |||
| auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
| Shade a cell | Excel Discussion (Misc queries) | |||
| Can I Shade Text Only In A Cell? | Excel Discussion (Misc queries) | |||
| How do I shade only 1/2 of a cell? | Charts and Charting in Excel | |||
Linear Mode
