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
I'm here to help you today.
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
Please follow the instruction. Please open a excel file same as one on the preview window.
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
[Uploaded an Excel file]
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
ready?
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.