highlight cell if greater than another cell

The rule is applied to cells which satisfy the criteria. NOTE: The criteria will differ depending on the option chosen in step 3. In the dialog box, specify your criteria. Select Highlight Cells Rules » select the desired criterion. Select the range of cells to be formatted.įrom the Home command tab, in the Styles group, click Conditional Formatting. The criteria can be number-based (e.g., greater than, less than, equal to), text-based (e.g., text contains, date occurring), or both (e.g., duplicate values). You can apply highlighting to cells if they satisfy criteria that you set. To create an original rule, refer to Creating a Customized Rule below. Using preformatted rules is a quick way to apply conditional formatting to your worksheet. Conditional formatting logs your formatting rules so you can edit, prioritize, and delete rules easily. You can apply preformatted rules, or you can create original rules. You can also format data bars to appear within the cell, making a concise bar graph within a worksheet. For example, in a list of numbers ranging from 1 to 10, you can format cells closer to 1 with red fill color, and cells closer to 10 with green fill color. This article is based on legacy software.Ĭonditional formatting rules allow you to format cells depending on how their data relates to other data. You have any doubt, mention it in the comments section below.(Archive) Microsoft Excel 2007: Working with Conditional Formatting I hope this article was explanatory enough to help you out on conditional formatting in excel. You just need to work around a little bit. This sounds tricky but in practice, it is quite easy. So yeah guys, this how can do conditional formatting in excel based on another column.

Just use a comma between ranges in 'applied to' section. You can also mention the non-connected ranges. The column can be on the different sheet too. Similarly, you can format any range based on any column in excel. You can see that formatting is applied to the mentioned reference.

Change the range in 'Applies to' box to A2:A12.

If you wanted to highlight months on instead of sales in 2019, you can directly change 'formula applies to' to the range A2:A12. Now, D2 is compared with C2, since D2 is greater than C2, D2 is filled with green colour. This is called half absolute referencing. Here we have locked columns and allowed rows to change.

Next, we use a formula to determine which cell to format in the selected range. First, we select the range on which we want the formula to apply. All the values in sales 2019 that are greater than the sales in 2018 are highlighted with green fill. I have selected a green fill.Īnd it's done.

Select the formatting of the cell if the condition is true.

Highlight cell if greater than another cell