To compare one cell to another cell

[asanders]

To compare one cell to another cell

--------------------------------------------------------------------------------

I would like to compare, for example, cell A1 to cell B1 on the same worksheet. I want to input a number into cell A1 and that number would be my reference to determine if B1 is greater than, less than or equal to that number. If B1 is less than I want that number to show up in red if the number is equal to, another color and so on. Is there a formula to make that possible?

[TMS]

You need to use Conditional Formatting.


Regards

[tigeravatar]

asanders,

You would use conditional formatting in cell A1 to get the desired results.

Hope that helps,
~tigeravatar

EDIT: Beat by TMS

[tigertiger]

Of course, it is possible by using conditional format

+select A1
+Click "Format" > "Conditional Formatting"
+ choose Formula in the first combo box, then type =$A$1>$B$1 (you can point the cells by mouse)
+ Press Format.. button -> choosing the color and smt else you like
+ finish by OK button

Plz see the link for detail of conditional format: http://www.wikihow.com/Apply-Conditi...tting-in-Excel

[TMS]

@tigertiger: only by a minute ... and now you've gone the extra mile ;-)

[asanders]

Perfect!! Thanks guys!!!

[snb]

You could use this macro:

Please Login or Register  to view this content.