Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a cell to turn "white" when filled in...
Hey guys
I've created a "sheet" for our sales guys to fill out...i've given them a drop-down (validation list) box with their accounts that they can choose from. I'd like to have the cells grey until they choose their account name this way they know what they need to fill out...then when they choose their account name, I want the cell to fill in white (normal)...i've tried to do it via conditional formatting, but can't seem to figure it out. Any help would be great!!! Thanks in advance for your help!! -JC |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a cell to turn "white" when filled in...
You talk about "the cells" and "the cell". Which cell/cells are to have
condtional formatting? For the Data Validation cell(s) , set the background to grey and then: Highlight cell(s): FormulaIs: =B2<"" Pattern: No colour HTH "JC" wrote: Hey guys I've created a "sheet" for our sales guys to fill out...i've given them a drop-down (validation list) box with their accounts that they can choose from. I'd like to have the cells grey until they choose their account name this way they know what they need to fill out...then when they choose their account name, I want the cell to fill in white (normal)...i've tried to do it via conditional formatting, but can't seem to figure it out. Any help would be great!!! Thanks in advance for your help!! -JC |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a cell to turn "white" when filled in...
Select the range of cells (I used D10:D20)
Use command Format | Conditional Formatting In dialog box, set to Formula Is and enter =ISBLANK(D10); click Format button; open Pattern tab and select a grey tone Click OK twice to close dialog best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JC" wrote in message ... Hey guys I've created a "sheet" for our sales guys to fill out...i've given them a drop-down (validation list) box with their accounts that they can choose from. I'd like to have the cells grey until they choose their account name this way they know what they need to fill out...then when they choose their account name, I want the cell to fill in white (normal)...i've tried to do it via conditional formatting, but can't seem to figure it out. Any help would be great!!! Thanks in advance for your help!! -JC |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a cell to turn "white" when filled in...
Toppers:
That formula is EXACTLY what is was looking for!!! I was close...i was one quotation off! Thank-you VERY much for your prompt response!!!! "Toppers" wrote: You talk about "the cells" and "the cell". Which cell/cells are to have condtional formatting? For the Data Validation cell(s) , set the background to grey and then: Highlight cell(s): FormulaIs: =B2<"" Pattern: No colour HTH "JC" wrote: Hey guys I've created a "sheet" for our sales guys to fill out...i've given them a drop-down (validation list) box with their accounts that they can choose from. I'd like to have the cells grey until they choose their account name this way they know what they need to fill out...then when they choose their account name, I want the cell to fill in white (normal)...i've tried to do it via conditional formatting, but can't seem to figure it out. Any help would be great!!! Thanks in advance for your help!! -JC |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a cell to turn "white" when filled in...
Bernard's solution is "better"!
"JC" wrote: Toppers: That formula is EXACTLY what is was looking for!!! I was close...i was one quotation off! Thank-you VERY much for your prompt response!!!! "Toppers" wrote: You talk about "the cells" and "the cell". Which cell/cells are to have condtional formatting? For the Data Validation cell(s) , set the background to grey and then: Highlight cell(s): FormulaIs: =B2<"" Pattern: No colour HTH "JC" wrote: Hey guys I've created a "sheet" for our sales guys to fill out...i've given them a drop-down (validation list) box with their accounts that they can choose from. I'd like to have the cells grey until they choose their account name this way they know what they need to fill out...then when they choose their account name, I want the cell to fill in white (normal)...i've tried to do it via conditional formatting, but can't seem to figure it out. Any help would be great!!! Thanks in advance for your help!! -JC |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a cell to turn "white" when filled in...
Great!! They both work as needed!! Thanks again for all your help guys!!!
I appreciate it!! "Bernard Liengme" wrote: Select the range of cells (I used D10:D20) Use command Format | Conditional Formatting In dialog box, set to Formula Is and enter =ISBLANK(D10); click Format button; open Pattern tab and select a grey tone Click OK twice to close dialog best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JC" wrote in message ... Hey guys I've created a "sheet" for our sales guys to fill out...i've given them a drop-down (validation list) box with their accounts that they can choose from. I'd like to have the cells grey until they choose their account name this way they know what they need to fill out...then when they choose their account name, I want the cell to fill in white (normal)...i've tried to do it via conditional formatting, but can't seem to figure it out. Any help would be great!!! Thanks in advance for your help!! -JC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditiona Formatting to "white out" #N/A | Excel Discussion (Misc queries) | |||
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
"Turn "record macro" display on. | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
How do I turn on "pressing enter goes to the next cell" option? | Excel Discussion (Misc queries) |