0

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?

1
  • share a copy of your sheet
    – user0
    Apr 21, 2019 at 15:58

1 Answer 1

1

red color:

=IF(ARRAYFORMULA(IF(LEN(B5:T6),
 IF(B5:T5 > B6:T6, 2,
 IF(B5:T5 < B6:T6, 2, )), ))=2, 1)

green color:

=IF(ARRAYFORMULA(IF(LEN(B$5:T6),
 IF(B$5:T$5 = B$6:T$6, 1, ), ))=1, 1)

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.