**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.*