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.