Forum Discussion

null null's avatar
null null
Copper Contributor
May 19, 2018

Conditional Formatting

I want to conditionally format the following data to be based on multiple cells data. 

If G2>0, but F2=0, then the whole row has a red fill. If F2 and G2 both =0, a yellow fill, if F2>0, no matter G2's value, a green fill

 

I know how to format based on one value, so I can fill in the green based on F2>0, but how do you base the conditional formatting on the separate values of two cells?

DayDistrictRouteCarrierLastNameCarrierFirstNameCurrent %Current-7Current-14
Wednesday150118239WHITELEYKIM0.00%50.00%0.00%
Wednesday150104139SICHKARLYUBOV0.00%0.00%0.00%
Wednesday150104171SICHKARLYUBOV0.00%0.00%0.00%
Wednesday150104156PICKELRENE100.00%0.00%0.00%
Wednesday150101177PICKELRENE96.00%0.00%0.00%
Wednesday150104148PICKELRENE80.00%0.00%0.00%
Wednesday150101130NELSONKERI94.00%0.00%94.00%
Wednesday150101157NELSONKERI72.00%0.00%100.00%
Wednesday150101165NACCARATOJOHN0.00%25.00%0.00%
Wednesday150101128MOYSEYENKOOLEKSIY100.00%100.00%100.00%
Wednesday150143102MOYSEYENKOOLEKSIY89.00%0.00%91.00%
Wednesday150101133MOYSEYENKOOLEKSIY37.00%81.00%97.00%
Wednesday150104142KRAUSSJOHN100.00%100.00%100.00%
Wednesday150104140KRAUSSJOHN98.00%98.00%100.00%
Wednesday150118121KORZONTHOWSKIMATTHEW0.00%0.00%0.00%
Wednesday150118147KORZONTHOWSKIMATTHEW0.00%0.00%0.00%
Wednesday150118151KORZONTHOWSKIMATTHEW0.00%0.00%0.00%
Wednesday150118225KORZONTHOWSKIMATTHEW0.00%0.00%0.00%
Formulas & Functions
Need Help
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 20, 2018

    Null Null-

     

    You'll need to make 3 separate rules.  If you want to have one evaluated before another or vice versa you can reorder the them in the Conditional Formatting Pane by using the arrow keys to move the order of evaluation.  Please see the attached file for reference:

     

    The formulas I have used are as follows:

    Red =AND($F2=0,$G2>0)

    Yellow=AND($F2=0,$G2=0)

    Green=$F2>0

     

     

Resources