How to add cell color to a cell using if statement?

[BUSS111]

I am needing to do the following:

I have a challenge with 3 different events. I have the total score column calculating the sum of all three events. I am trying to fill the total score column red if one of the event scores is lower than 60.

Can I manually use an if statement to fill cell color?

 

[Marcílio_Lobão]

BUSS111, Good afternoon.

Try to use a SUMIF and OR functions at Conditional Format to color cell with the total score.

I hope it helps.

 

[BUSS111]

Yes that works thankyou.

 

[Marcílio_Lobão]

BUSS111, Good evening.

Thanks for the feedback.

Glad to help you.

Have a nice week!