excel formatting formula if one cell does not equal another

If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Remove the $ sign before the number of rows/numerical figures to get accurate results. The formula is automatically locked in the rule description section and appears like this: Same process and formula from Example # 1 is followed in Example # 2 and the final figure is given below. We can separate unequal boxes from the boxes of equal measurements with the help of conditional formatting. In this example, we’ll apply conditional formatting in order to highlight the boxes with unequal length and width. This is another example of conditional formatting where cells are not equal. Press OK to apply conditional formatting.ĭo the same with Column F and the unequal cells will appear highlighted as given in the figure below.įigure 4.

“New Formatting Rule” window will appear like this.

Now click on the ‘format” option to select format of your choice like color of the formatted cells etc.įigure 2.

( The sign is referred as “Not Equal to” sign in Excel )

In order to write the formula in the “Rule Description” bar, Select cell C2 to C14, put a “Not Equal to” sign and then select cells from B2 to B14.

Choose the rule type written as “Use a formula to determine which cells to format” from window.

Click the option of “New Rule” and “New formatting Rule” window will appear.

Select conditional formatting in the “Styles” section of the toolbar.

Select cells of column C from C2 to C14.

Or we can say, we need to highlight the cells of Column C and F that are not equal to the cells of Column B and E. We need to use conditional formatting to highlight the students with a GPA less than 4 in order to avoid them for selection. Only those students will be selected for scholarship that got 4 out of 4 GPA. This data refers to the total and obtained GPA of students. This step by step tutorial will assist all levels of Excel users in conditional formatting two cells that are not equal. Here’s How You Can Use Conditional Formatting If Two Cells Are Not EqualĬonditional formatting is one of the most useful functions of Excel.

Excel formatting formula if one cell does not equal another