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.