I would like to have the cell color changed according to what value is chosen from a drop down menu. I guess you need to make some kind of rule with conditional formatting, but I haven't figured it out...
I would like to have the cell color changed according to what value is chosen from a drop down menu. I guess you need to make some kind of rule with conditional formatting, but I haven't figured it out...
You quess correctly.
One rule per eatch value.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Cool. So now I know it theory How would one go about doing this in practice?
The theory is 90%. So now for the rest you have 2 options.
1) Try in conditional formatting rules like that.
=a1= "value1" >>color a
=a1="value2"| >>color 2 etc....
2)upload a small sample workbook..
Thanks!
So in the new formatting rule box I chose 'format only cells that contain' and I chose 'specific text' and then format the color. The thing is that the drop down menu pulls the values from a different sheet and when I chose different values it doesn't appear to take into account the formatting rule that has been made. And don't want to format each drop down menu because I'll be having a lot of them.
Different values?...?.....and when I chose different values it doesn't appear ....
Pls upload a small sample workbook. This will helps us to understand your query.
Yes, here's the workbook.
Two columns and I want the colors of the values in the left column to be shown when you choose a value from the drop-down menu.
Appreciate the help.
Like this?
Thanks fotis!
But it's not really what I'm looking for.
Because in the real document you won't be able to see the value column as it will be in a different sheet and I want the cell within the drop down menu to take on the same color as I assign to the value.
So When I choose A in the drop down menu I want that to become purple, for instance.
What the meaning of showing to us a sample workbook that is something different than you real workbook is?
Yes, this was an error on my part I realize now and the mistake is acknowledged for future reference.
So Jonathan, if you still need help on this, pls upload a sample workbook that looks like exactly as your original, explaining the expected results.
Alright, here's the 2nd try
In CF, just change the 'applies to' field to $B$2:$B$7 for all rules. See attached
Last edited by Ace_XL; 06-17-2013 at 04:05 AM.
Life's a spreadsheet, Excel!
Say thanks, Click *
CF down with new example
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks very much for the help!
Just wanted to clarify on thing then we can close this thread
Where do I add the "applies to" cells?
In sheet 2 we have the values the drop down pulls from - I'll highlight those cells and then select the cells in the drop down from sheet 1? Because that doesn't really work.
When I select cells in a different sheet in the "applies to" the sheet 1 just disappear...
See attached. Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks