![]() 2.1 Click Use a formula to determine which cells to format option in the Select a Rule Type section.In the New Formatting Rule dialog box, please configure as follows. Select the column cells you will highlight (here I select range B2:B13), and then click Home > Conditional Formatting > New Rule.Ģ. Supposing you have a table as the below screenshot shown, and want to highlight cells in column B if the adjacent cell values in column C are greater than 800, please apply the Conditional Formatting function as follows.ġ. More tutorials for Conditional Formatting… Have you ever tried to apply conditional formatting to a column based on values in a separate column in Excel? This tutorial will guide you how to solve the problem.Īpply conditional formatting based on values in another column ![]() ![]() How to apply conditional formatting to a column based on another column in Excel?
0 Comments
Leave a Reply. |