MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Flag a cell?

Posted by Lisa Perry on February 08, 2002 6:26 AM

Is it possible to flag a cell when the number placed in that cell is greater than another specific cell?

If so could someone help me with a formula for this?


Posted by Mudface on February 08, 2002 6:31 AM

You can use conditional formatting formulas for this. As a simple example, select cell A1 and Format-Conditional Formatting. Change the Condition 1 dropdown to 'Formula is' and enter
=(B1>A1), then choose a format.

Now, whenever the value in B1 is greater than A1 that cell will be formatted in the style you chose. Note that you can select the whole of column A and enter the same formula, which will then work for each cell in Column A (as the reference is relative).