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.
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?
 
Roy CoxGroup Finance ManagerCommented:
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
0
 
Bill GoldenExecutive Managing MemberAuthor 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)
0
 
Bill GoldenExecutive Managing MemberAuthor Commented:
Got it!  Had to do a little reading on conditional formatting, but your solution put me on the right track.  Thanks.
0
 
Roy CoxGroup Finance ManagerCommented:
Glad to have helped.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.