Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling Blank Cells
I have a wksht where I want to have all blank cells auto color fill to
indicate data not yet rec'd/entered. Conitional formatting requires a value be assigned - have tried to leave value as blank, and apply formatting, but it doesn't work - there's got to be an easy answer and I'm just not seeing it! Help - it's driving me nuts!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling Blank Cells
Use formula is
=A1="" will work OR cell value equal to ="" -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Mary Mayo" wrote in message ... I have a wksht where I want to have all blank cells auto color fill to indicate data not yet rec'd/entered. Conitional formatting requires a value be assigned - have tried to leave value as blank, and apply formatting, but it doesn't work - there's got to be an easy answer and I'm just not seeing it! Help - it's driving me nuts!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling Blank Cells
You are almost there!
for A1: Format Conditional formatting... Formula is =ISBLANK(A1) and set your special "blank cell format" copy the format to any cell you like -- Gary's Student "Mary Mayo" wrote: I have a wksht where I want to have all blank cells auto color fill to indicate data not yet rec'd/entered. Conitional formatting requires a value be assigned - have tried to leave value as blank, and apply formatting, but it doesn't work - there's got to be an easy answer and I'm just not seeing it! Help - it's driving me nuts!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking Blank Cells | Excel Worksheet Functions | |||
Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) |