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

    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.

    Please i would be so grateful for your assistance.

    Book1 (1) (1).xlsx

    Thanks

    Best regards

    BlueOcean

    Edited 4 times, last by AliGW ().

  • AliGW

    Added the Label Cross Post
  • Cross-posted on THREE other forums.


    Please read our rules before posting here again: Forum Rules

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

    Edited once, last by AliGW ().

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!