LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Conditional formatting and Dropdowns

Without creating a circular reference, is it possible to place a dropdown in
a cell whereby when the user makes a selection (alpha and not numeric) the
cell the dropdown is in will change color based on the selection from the
dropdown?

I noticed that the Conditional Formatting dropdown only allows for 3 options
(if, then, else?) I recently set up a form using numeric entries that worked
fine but have a requirement to set up a scenario whereby the cell starts off
blank... user selects A from dropdown and cell turns red/white type... or B
and cell turns green/white type... or C and cell turns white/black type.
This is replicated 36 times on a rating form (protected sheet/workbook) in
Excel 2003.

Can this be accomplished? Is any of the process dependent on whether the
cell/worksheet/workbook is protected? My thanks for any assistance with this
problem.... regards
 
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
Conditional List dropdowns? GD Excel Discussion (Misc queries) 1 October 27th 09 04:44 PM
Formatting cells in a column with conditional formatting? shamor Excel Discussion (Misc queries) 8 May 19th 08 10:11 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 0 January 15th 07 04:35 PM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM


All times are GMT +1. The time now is 09:10 PM.

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"