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 ...
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.
Can send copy on file I am confuse
sry i meant to attach it
Please attach file. I downloaded the image is not clear.