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
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.
Please i would be so grateful for your assistance.