![]() ![]() Note: In the formula, $C2 is the first cell of the column that contains the criteria you need, and >800 is the criteria you will highlight cells based on. 2.3 Click the Format button to specify a fill color.2.2 Copy the below formula into the Format values where this formula is true box.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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |