Question description:
This user has given permission to use the problem statement for this
blog.
Column C contains numbers only from rows 9 to 21. These could be either whole numbers - 1, 2, 3 etc or decimal numbers 3.5, 4.2 or 5.0. Minimum is 1 max is 5. If a cell C9 - C21 does not have a number then Cell H21 to insert 'ERROR' and conditional format cell to warning colour - red.
Solved by A. J. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
01/05/2018 - 10:42
Hi
Excelchat Expert
01/05/2018 - 10:42
Welcome to got it pro
Excelchat Expert
01/05/2018 - 10:42
Can you paste you sample data so that i can help better
Excelchat Expert
01/05/2018 - 10:44
Data is not till C21
Excelchat Expert
01/05/2018 - 10:44
Many cells in C9 to C21 do not have a number
Excelchat Expert
01/05/2018 - 10:45
i think you are talking about C2 to C14
Excelchat Expert
01/05/2018 - 10:46
and then inserting ERROR in H14
Excelchat Expert
01/05/2018 - 10:46
am i correct?
User
01/05/2018 - 10:46
I have only copied part of a table - the key element is that col C must have a number whole or decimal. In this example H 14 to go red with 'ERROR' if there is an empty cell in C.
Excelchat Expert
01/05/2018 - 10:47
See now
Excelchat Expert
01/05/2018 - 10:48
Try removing one value from column C and check
Excelchat Expert
01/05/2018 - 10:48
Does this help?
Excelchat Expert
01/05/2018 - 10:48
I have used if function to display error
Excelchat Expert
01/05/2018 - 10:48
and conditional formatting to colour the cell when it shows ERROR
Excelchat Expert
01/05/2018 - 10:48
Let me know if this helps?
User
01/05/2018 - 10:49
Spot on. Perfect. Great. Many thanks.
Excelchat Expert
01/05/2018 - 10:49
Welcome
Excelchat Expert
01/05/2018 - 10:49
Please do give good rating and reviews
Excelchat Expert
01/05/2018 - 10:49
It would really help a lot
User
01/05/2018 - 10:49
Will know try in live environment, hang on.
Excelchat Expert
01/05/2018 - 10:49
Sure
Excelchat Expert
01/05/2018 - 10:49
you can download this file for you reference
Excelchat Expert
01/05/2018 - 10:51
Once you end the session please don't forget to give good rating
User
01/05/2018 - 10:51
Just tried in live environment, works perfectly, I now understand how it works so shall be able to use many times. Many thanks and have a great day.
Excelchat Expert
01/05/2018 - 10:51
Same to you
Excelchat Expert
01/05/2018 - 10:51
:)
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.