Forum Discussion
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 G...
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