All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

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

i need a formula to highlight the cells, i will enter the total value excel should highlight the cells which sum equals to that value
Solved by K. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/03/2018 - 09:29
Hello!
Excelchat Expert 02/03/2018 - 09:29
Welcome to excelchat!
Excelchat Expert 02/03/2018 - 09:30
can you please show me the worksheet on which you are working?
User 02/03/2018 - 09:30
hi
Excelchat Expert 02/03/2018 - 09:30
hello
Excelchat Expert 02/03/2018 - 09:31
can you please show me the worksheet on which you are working?
User 02/03/2018 - 09:31
yeah
Excelchat Expert 02/03/2018 - 09:31
plase share the file using attach button
Excelchat Expert 02/03/2018 - 09:31
as this is a conditional formatting related task i will have to do this locally on my pc
Excelchat Expert 02/03/2018 - 09:32
ok which column you want to highlight?
Excelchat Expert 02/03/2018 - 09:32
and what is the condition?
Excelchat Expert 02/03/2018 - 09:34
there?
User 02/03/2018 - 09:34
if i enter any value in total sent execel should highlight the cell which are cover within the value
Excelchat Expert 02/03/2018 - 09:35
can you tell me an example actually i want it to be done correctly
Excelchat Expert 02/03/2018 - 09:35
like is first row ?
Excelchat Expert 02/03/2018 - 09:35
total sent is 2
Excelchat Expert 02/03/2018 - 09:35
why this should be highlighted or not highlighted ?
User 02/03/2018 - 09:36
both cell should get highlighted
Excelchat Expert 02/03/2018 - 09:36
column b and column h?
User 02/03/2018 - 09:36
it will assure that upto which machine i have supplied the part to customer
Excelchat Expert 02/03/2018 - 09:37
ok
Excelchat Expert 02/03/2018 - 09:37
you want any colour if its less then required?
User 02/03/2018 - 09:38
no
Excelchat Expert 02/03/2018 - 09:38
in row 3 required is 1 and sent is 2 is this possible?
User 02/03/2018 - 09:38
yeah it is possible
Excelchat Expert 02/03/2018 - 09:38
ok please wait
Excelchat Expert 02/03/2018 - 09:44
please check this file
[Uploaded an Excel file]
User 02/03/2018 - 09:45
but how to do that
Excelchat Expert 02/03/2018 - 09:45
see this can be done using conditional formatting
User 02/03/2018 - 09:45
how
Excelchat Expert 02/03/2018 - 09:46
you select the column to which you want to highlight
Excelchat Expert 02/03/2018 - 09:46
then go on conditional formatting
User 02/03/2018 - 09:46
ok
Excelchat Expert 02/03/2018 - 09:46
there is a option highlight cell rules
User 02/03/2018 - 09:46
ok
Excelchat Expert 02/03/2018 - 09:47
select equal to
User 02/03/2018 - 09:47
ok
Excelchat Expert 02/03/2018 - 09:47
and type =first cell of column to which you want to compare
Excelchat Expert 02/03/2018 - 09:47
and click ok thats it
Excelchat Expert 02/03/2018 - 09:47
got it?
User 02/03/2018 - 09:48
ok thank you dear
Excelchat Expert 02/03/2018 - 09:48
most welcome
Excelchat Expert 02/03/2018 - 09:48
lease end this session
Excelchat Expert 02/03/2018 - 09:48
you dont have further queries
Excelchat Expert 02/03/2018 - 09:49
and dont forget to rate me
User 02/03/2018 - 09:49
let me try this
Excelchat Expert 02/03/2018 - 09:49
sure
Excelchat Expert 02/03/2018 - 09:49
let me now if its working
User 02/03/2018 - 09:49
yes of course i will

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc