# Conditional formatting/coloring depending on values of 2 different cells

• Conditional formatting/coloring depending on values of 2 different cells
Hello I have spent my whole 2 full days trying to solve this one and i was no able therefore i am asking please for your help. I have a simple table that…
www.mrexcel.com

Conditional formatting/coloring depending on values of 2 different cells
Hello I have spent my whole 2 full days trying to solve this one and i was no able therefore i am asking please for your help. I have a simple table that…
forums.excelguru.ca

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

Hello

I have spent my whole 2 full days trying to solve this one and i was no able therefore i am asking please for your help.

I have a simple table that includes 3 Tactics : A, B and C.

Each Tactic is defined by 2 numerical parameters (Parameter 1 and Parameter 2) which are set and fixed in advance (I do not modify them).

Tactic A is the best then comes B and last is C.

Tactic A has the lowest parameters then comes B then C.

Each day i measure from the stars in the sky parameters 1 and 2 for the Day and insert them in my table (in the 2 cells in Yellow).

For me to be able to use a tactic, both parameters measured for the day MUST be below the predefined parameters for the tactic to be used.

Then I would like, please, that my table automatically formats/colors in Green only one Tactic that has both parameters 1 and 2 below the parameters measured for the day.

In case the parameters of the day allow me to use several Tactics then i would like, please, that the table only highlights the best tactic: A, then B then C.

I have attached the table in 4 different examples with 4 different sets of parameters for the day an example:

Case 1 The parameters for the day fall under the parameters of all 3 tactics, but since tactic A is the best then it is solely colored in green.

NB:i do not mind if only cell A is colored in green and not the whole line for the parameters

Case 2 we can see that parameter 1 is not OK for tactic A but OK for tactic B and C. On the other hand parameter 2 is OK for all 3 tactics therefore we have the choice between tactic B and C only (since A is excluded due to parameter 1). Since B is better than C only B is colored in green.

Case 3 Parameter 1 is OK for 3 tactics but since parameter 2 is only OK for tactic C then Tactic C is colored in green only

Case 4 all parameters are not OK for all 3 tactics so nothing is colored in green.

Book1 (1) (1).xlsx

Thanks

Best regards

BlueOcean

Edited 4 times, last by AliGW ().

• ## AliGWOct 15th 2022

• Cross-posted on THREE other forums.