**Question description:**

*This user has given permission to use the problem statement for this blog.*

Wanted the cell to indicate if number is +/- from desired total

Solved by D. D. in 32 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
29/05/2018 - 08:04

Hello

Excelchat Expert
29/05/2018 - 08:05

Welcome to excelchat.

Excelchat Expert
29/05/2018 - 08:05

We are happy to have you today with us.

User
29/05/2018 - 08:05

Hello

Excelchat Expert
29/05/2018 - 08:06

Please tell me details, I want to be sure that I understand the problem clearly.

User
29/05/2018 - 08:06

would like the total (for expamle D9) to display +/1 a specific total

Excelchat Expert
29/05/2018 - 08:08

I'm sorry, I'm not sure what does that mean. I understand that you have tried your best. My apologies but I need more information.

User
29/05/2018 - 08:08

if the total is three would like the number to be green at three and red for any other number

Excelchat Expert
29/05/2018 - 08:08

Alright, it seems conditional formatting problem.

User
29/05/2018 - 08:09

I want to know if the total is at the correct value

Excelchat Expert
29/05/2018 - 08:09

So, may I know which cell indicates the total?

User
29/05/2018 - 08:10

D15 - D21 would be the ones i am looking to indicate if the value has been reached (green) or if its over/under (red)

Excelchat Expert
29/05/2018 - 08:11

Okay. Understood.

Excelchat Expert
29/05/2018 - 08:11

What is the number that indicates a value has been reached?

Excelchat Expert
29/05/2018 - 08:11

Is it 3?

User
29/05/2018 - 08:12

each day of the week would have a different total. Monday - Friday each day I need 3 QC and 3 EC and one CH

User
29/05/2018 - 08:13

Sat and sunday I need 2 PNO 2 CH and 2 FZ

Excelchat Expert
29/05/2018 - 08:14

Is there anything else?

User
29/05/2018 - 08:14

no the others are one off events.

Excelchat Expert
29/05/2018 - 08:15

Thank you, do you want me to show how to do it or you just want me to do the task?

User
29/05/2018 - 08:15

Sat CH and PNO are the same people which means the cell is CH/PNO

User
29/05/2018 - 08:16

you can just do it and i will work with the formula

Excelchat Expert
29/05/2018 - 08:16

Thank you.

Excelchat Expert
29/05/2018 - 08:22

Okay, I have formatted accordingly, please check.

User
29/05/2018 - 08:24

on saturday is CH/PNO treated as to separate inputs. Both CH and PNO not CH/PNO

Excelchat Expert
29/05/2018 - 08:25

I'm sorry?

Excelchat Expert
29/05/2018 - 08:26

My apologies, I think you have asked to format the cells based on value reached.

Excelchat Expert
29/05/2018 - 08:27

I can't relate the statement "on saturday is CH/PNO treated as to separate inputs. Both CH and PNO not CH/PNO" to the formatting problem

Excelchat Expert
29/05/2018 - 08:31

Please let me know if you were looking for something else.

User
29/05/2018 - 08:33

E11 CH/PNO does this count in totals?

Excelchat Expert
29/05/2018 - 08:35

I'm sorry, if you also want me to count the words in the range above, please let me know. Otherwise I don't know what you mean.

User
29/05/2018 - 08:36

ok thanks for your help

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