Google Sheets to keep up with High School Football Scores [Closed]

Report
Posts
1
Registration date
Wednesday August 30, 2017
Status
Member
Last seen
August 30, 2017
-
Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
-
Hello,

Ok I am creating a google spreadsheet to keep up with High School Football Scores. I would like help with a formula that allows me to color code a particular cell based on the value of another cell. i.e. (if G4:G5="F" then color code E4:E5:F4:F5 red) and on the flip side if G4:G5are greater than 0 then color code E4:E5:F4:F5 green). I can get it to color of of the four cells but not all four based on the value of G4:G5.

1 reply

Posts
1843
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 29, 2020
136
cjradio, Good afternoon.

Try to do:

Select range E4:F5
Menu Conditional Format --> Using Formula

Rule 1
Type --> =COUNTIF(G4:G5,"F")=2
Format Fill Color RED
OK

Rule 2
Type --> =COUNTIF(G4:G5,">0")=2
Format Fill Color GREEN
OK

Please, tell us if its working as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão