![]() If you are using Excel 2013 or later versions, you can use the AutoFill handle to apply the conditional rule to adjacent rows. ![]() Then this conditional formatting rule will be applied to each row in the new range. In the Conditional Formatting Rules Manager dialog, find the rule you applied to A2:B2, change the range as you need in Applies to section, and click OK. ![]() Keep A2:B2 selected, click Home > Conditional Formatting > Manage Rules.ĥ. Now the row A2:B2 is applied conditional formatting.Ĥ. ![]() Click Format button to go to the Format Cells dialog, and then you can choose one formatting type as you need. 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. |