# Excel - IF Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.