LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jc jc is offline
external usenet poster
 
Posts: 164
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditiona Formatting to "white out" #N/A Lele Excel Discussion (Misc queries) 4 February 24th 07 06:14 PM
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 kakasay Excel Discussion (Misc queries) 1 January 22nd 07 12:31 PM
"Turn "record macro" display on. greaseman Excel Discussion (Misc queries) 2 April 28th 06 05:58 PM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM
How do I turn on "pressing enter goes to the next cell" option? Hollywood Excel Discussion (Misc queries) 6 December 20th 05 09:10 PM


All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"