Forum Discussion
I have conditional formatting formula is not working. I help with it.
I have a conditional formatting formula that is not working. I help with it.
I need help with highlighting green if I got the right pick.
I need help with highlighting red if I got the wrong pick.
I put P where I think cell F6:F21.
Thank You
Assuming the #1 under "Games" is B3 (and it will need to be at least column B for this formula to work so you could insert and hide a blank column A if needed), then highlight C3:I18 and under custom formula try this for green (right):
=ISNUMBER(XMATCH("P", A3:C3))*(SUM(C3:E3)>SUM($E3,$I3)/2)
red (wrong):
=ISNUMBER(XMATCH("P", A3:C3))*(SUM(C3:E3)<=SUM($E3,$I3)/2)
it look at P and scores. p could be on either side. if possible give answer on file please
First column is B
Thanks You
I happened to have helped you a long time ago so had a file that was basically the same. I did exactly what I suggested above and it worked perfectly. I inserted a blank column A to push the Games column to B; highlighted C3:I18; added new rule and pasted the above formula (but replaced "p" with "*" for this old file) and it worked perfect:
notice the light green is the new rule, the dark green rules and red rules are the old rules.
