Formatting a cell to turn "white" when filled in...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JC - 31 Jul 2007 19:52 GMT

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 to this Message

Toppers - 31 Jul 2007 20:06 GMT

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

> Hey guys
> I've created a "sheet" for our sales guys to fill out...i've given them a
[quoted text clipped - 7 lines]
> Thanks in advance for your help!!
> -JC

Reply to this Message

JC - 31 Jul 2007 20:30 GMT

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!!!!

> You talk about "the cells" and "the cell". Which cell/cells are to have
> condtional formatting?
[quoted text clipped - 19 lines]
> > Thanks in advance for your help!!
> > -JC

Reply to this Message

Toppers - 31 Jul 2007 20:36 GMT

Bernard's solution is "better"!

> Toppers:
> That formula is EXACTLY what is was looking for!!! I was close...i was one
[quoted text clipped - 23 lines]
> > > Thanks in advance for your help!!
> > > -JC

Reply to this Message

Bernard Liengme - 31 Jul 2007 20:11 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hey guys
> I've created a "sheet" for our sales guys to fill out...i've given them a
[quoted text clipped - 11 lines]
> Thanks in advance for your help!!
> -JC

Reply to this Message

JC - 31 Jul 2007 20:54 GMT

Great!! They both work as needed!! Thanks again for all your help guys!!!
I appreciate it!!

> Select the range of cells (I used D10:D20)
> Use command Format | Conditional Formatting
[quoted text clipped - 17 lines]
> > Thanks in advance for your help!!
> > -JC

Reply to this Message