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.