We help IT Professionals succeed at work.

Comparing the value of two cells then print messages in black or red

I want to constantly monitor the total of two columns. I have totals of two columns in A20 and B20.  If the totals are the same, I want to print to print "Your entries are in balance" in C20, if not in balance I want to print IN RED, "Your entries are out of balance" i C20 instead.
Comment
Watch Question

Group Finance Manager
Commented:
Use this formula

=IF(A20>B20,"Your entries are out of balance", "Your entries are in balance")

Add a conditional formatting rule using this formula

=$A$20>$B$20

Format Font to be Red
EE-CF.xlsm
Bill GoldenExecutive Managing Member

Author

Commented:
The syntax only works if A20 is greater than B20.  So, I changed the formula to read...

=IF(A20=B20,"Your entries are in balance","Your entries are out of balance")

which returns the appropriate message.  However, I am unsure of how to do conditional formatting.

(Working in Excel 2003)
Bill GoldenExecutive Managing Member

Author

Commented:
Got it!  Had to do a little reading on conditional formatting, but your solution put me on the right track.  Thanks.
Roy CoxGroup Finance Manager

Commented:
Glad to have helped.