Previous Topic Next Topic

Google Sheets to keep up with High School Football Scores

Closed
cjradio Posts 1 Registration date Wednesday August 30, 2017 Status Member Last seen August 30, 2017 - Updated on Aug 30, 2017 at 04:14 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 30, 2017 at 03:41 PM
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.
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 30, 2017 at 03:41 PM
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
0

Similar discussions

School project
fumoney -
fumoney -

1 response