Excel Guru's i need your help...

P

PaulJC

Suspended / Banned
Messages
350
Name
Paul
Edit My Images
Yes
I know this can be done i just have no idea how... in Excel 2007...

I have a column (B) full of combo boxes (Created by Insert>Form Controls>Combo Box) which all have the same 3 option's (OUTSTANDING, COMPLETED and N/A) which is taken from S1:S3, and they are all individually cell linked to the cell they are in.

What i would like to happen is the Cell in Column D change fill colour based on the option selected in the combo box, Red for OUTSTANDING, Green for COMPLETED and blank for N/A.

I have Googled and tried a couple of solutions but none seem to work, can anyone point me in the right direction?

Many thanks

Paul
 
Conditional Formatting probably the easiest option. I'm running Mac Office so might be a different menu on Windoz, but for me it's Format > Conditional Formating
 
I did have a try with conditional formatting, but it didn't seem to pick up the values from the combo box at all when it was changed (although worked fine with text typed into another cell for testing).

I read somewhere that you have to reference the original data via the combo box, but i havnt got a clue how to do that and havnt yet managed to find someone that does apart from one person on a forum going "I done it that way" with out giving any details...lol
 
I don't have much time to help you now, but a point in a direction would be a Macro/VBA to be called on _Change() where it will take the value in combo box, use a Case Select and change the colour of a specific cell.
 
Thanks for that, that works pretty well and is where i'll end up if i cant get these combo boxes to work...

Having had a bit of a further play when you change the combo box value the cell it's attached to changed number based on the list position of the item you've selected (1-3 in this case) i cant seem to get the conditional formatting working off of that though...
 
Adam. said:
I don't have much time to help you now, but a point in a direction would be a Macro/VBA to be called on _Change() where it will take the value in combo box, use a Case Select and change the colour of a specific cell.
Click to expand...

I'm not in any rush and would love an explanation to that as it's just flown straight over my head lol :D
 
Have you entered a formula in the conditional formatting ie
=C2=1 format is red, =c2=2 format is green

then use format painter to copy conditional formatting to other cells?
 
Between you all i have sussed it, Adrian for the help and the example:thumbs:, Charlie for reminding me numbers are numbers so dont need to be in the quotation marks left from Adrians example :lol: and Adam, i'd still like to hear the alternative :D

Thank's all :thumbs:
 
You must log in or register to reply here.
Back
Top