In the New Formatting Rule dialog, select Use a formula to determine which cells to format from Select a Rule Type section, then type =$A2>$B2 into the textbox under Format values where this formula is true.ģ. If there are rules in the row already, just directly jump to the step 4.Ģ. Select A2:B2, then click Home > Conditional Formatting > New Rule. Firstly, apply the conditional formatting to A2:B2. Method A Change the Applies to in Conditional Formatting Rules Managerįor instance, here you want to apply the fill background color to the cells if A2>B2, A3>B3, …, An>Bn with conditional formatting.ġ.
0 Comments
Leave a Reply. |