I simply want to create a scoresheet comparing scores to par. If less than par then a red number, if more than par then highlight red, if equal to par then highlight green. Here is what I'm trying to accomplish:
Par = cell B5 thru J5 and L5 thru T5
Score = if B6 thru J6 and L6 thru T6 are lower than par, the number is red; if equal to par then highlight green; if greater than par then highlight red.
I've tried it numerous times and it doesn't work. Can someone assist, please?