0

I'm having a table (in this example) everyone should write their name behind the Fruit he likes most.
I'm creating a dropdown box based on all people who wrote their names anywhere. Based on the Name picked of this dropdown (B5), I want the color of the cell to change based on the most liked fruit. So now since I picked Mike I want this cell to color green. If I'd pick Steve I want it to change to yellow.

In my thoughts it should be something like: if text matches B2:X2 then color green else if text matches B3:X3 then color yellow

enter image description here

Update: Since I got this first question resolved, I now faced a different problem. When I have more then one of those dropdown boxes my rule doesn't work like expected.

enter image description here

On B7 it's working but since I copy and pasted this dropdown a couple times it doesn't work like expected. Sow my final goal would be to have a second table full of dropdown boxes with all names from table one. The conditional formatting I'd like to achieve here is:

If any dropdown box (B7,B8,B9,C7,C8,C9) got any name selected, color the cell green/yellow depending on where the name is in the first table.

0

I think I got this first one resolved. Another Row which basically says the same just for B3:C3 color yellow.

enter image description here

2
  • 1
    Since you question is new, it's better to edit your question to show your progress and include on it your follow-up question as per site guidelines follow up questions should not be included in answers
    – Rubén
    Jan 31 '21 at 21:37
  • thank you sir. I removed the follow up question.
    – Yaerox
    Jan 31 '21 at 21:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.