return a value of '1' if the lowest value amoung the two cell is green

[kingsy18]

Please do you know how to formulate the following condition in excel; when you have two cells one with high and the other with low value and one of the cell is colored green. so you want to return a value of '1' if the lowest value amoung the two cell is green color and '0' is the highest value amoung the cell is green. is there a condition or formula for the statement in excel

 

[dreid1011]

It's possible. How do you decide which cell gets colored green, or is it colored green from an outside source? Your answer will tell us if it can be done with a formula or if VBA is necessary.