Multiple ComboBox and Conditional Formating

[salmankhanfx]

Hello all,

Looking for some help on the VBA side of things in simple English

What I have is 2 worksheets.

Worksheet1: Has the RAG status (Red, Amber, Yellow, Blue, Gray)

Worksheet2: Has 2 different combo boxes for Schedule and Cost

What I Have is: in Worksheet2 with the Combo box I can select the color of the status and it will update the same color in Sheet1 of RAG status.

What I would like to Have: The RAG status in Sheet one is changed depending on AND/OR logical operation of the 2 combo boxes.

FOR EXAMPLE: Combo box 1 = Red, ComboBOx 2 = Amber, then I want to the change the status to Red

Truth Table:
Any combo box is Red: RAG is RED
Any combo box is Amber AND not Red: RAG is Amber
Any combo Box is Yellow and not Amber OR Red : RAG is Yellow
Any combo Box is Green and the other NOT red, amber or yellow: RAG is Green
If both combo box is blue: RAG Blue
If any combo box is gray then the other combo box color should be used.

Please see the attached excel and would appreciate the help

Thanks

[watersev]

hi salmankhanfx, please check attachment

[salmankhanfx]

hi salmankhanfx, please check attachment

Thank you sooo much - exactly what I needed