# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, I want to add two number and compare in same cell Ex : A. xx B. xx C. 25 Add A+B and compare with C. If A+B is greater than C , i want to show in red color.
Solved by V. C. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 01/05/2018 - 09:12
Other
Excelchat Expert 01/05/2018 - 09:13
Hello
Excelchat Expert 01/05/2018 - 09:13
Welcome to got it pro
Excelchat Expert 01/05/2018 - 09:13
Excelchat Expert 01/05/2018 - 09:13
I understand you want help with summation and then color formatting the sum figure, right?
User 01/05/2018 - 09:14
yes
User 01/05/2018 - 09:14
my right side preview is showing in Arabic
Excelchat Expert 01/05/2018 - 09:14
Can you show me a few examples in the preview window or better yet if you send me the excel file.
Excelchat Expert 01/05/2018 - 09:16
I can see them in english, so it might be in your browser settings.
User 01/05/2018 - 09:16
i want to show the E4 cell in red color
Excelchat Expert 01/05/2018 - 09:17
Please tell me the condition for E4 being red.
User 01/05/2018 - 09:18
E4 is greater than A4 , so i want to show in red color
Excelchat Expert 01/05/2018 - 09:19
understood, you will on on excel, right?
User 01/05/2018 - 09:19
yes
Excelchat Expert 01/05/2018 - 09:20
The feature we will be using to turn cell E4 to red is called conditional formatting.
User 01/05/2018 - 09:20
see
Excelchat Expert 01/05/2018 - 09:21
User 01/05/2018 - 09:21
ok
Excelchat Expert 01/05/2018 - 09:22
Let me know when you are ready.
Excelchat Expert 01/05/2018 - 09:23
Excelchat Expert 01/05/2018 - 09:23
Here is the file on preview window. You can also download and open it.
Excelchat Expert 01/05/2018 - 09:25
Excelchat Expert 01/05/2018 - 09:27
Hello, are you there?
User 01/05/2018 - 09:29
yes
Excelchat Expert 01/05/2018 - 09:29
okay, select cell E4, then click on the conditional formatting from excel ribbon.
User 01/05/2018 - 09:30
ok
Excelchat Expert 01/05/2018 - 09:31
do you see an option named "highlight cell rules"? if so, click on it. And then click on "greater than".
Excelchat Expert 01/05/2018 - 09:31
this will bring a pop up box. let me know when you see it.
User 01/05/2018 - 09:31
yes
Excelchat Expert 01/05/2018 - 09:32
in the text box, where it says "format cells greater than", put this formula =\$A4.
Excelchat Expert 01/05/2018 - 09:33
then click on OK.
User 01/05/2018 - 09:33
ok
Excelchat Expert 01/05/2018 - 09:34
that's it. if you have done the above things then you will be able to see cell E4 is turned red when it is greater than A4.
User 01/05/2018 - 09:34
no
User 01/05/2018 - 09:34
it is not red
User 01/05/2018 - 09:35
yes
User 01/05/2018 - 09:35
now turn red
Excelchat Expert 01/05/2018 - 09:35
brilliant. you have done it.
Excelchat Expert 01/05/2018 - 09:36
any question?
User 01/05/2018 - 09:36
no
User 01/05/2018 - 09:36
Thank you very much
Excelchat Expert 01/05/2018 - 09:37
okay, please close this chat now. I believe there is a close button on your side.
Excelchat Expert 01/05/2018 - 09:37
Thanks and have a great day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.