Excel - How to Apply Conditional Formatting to Blank Cells - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

How can I multiply the number of blank cells in a row by 5 using conditional formatting?
Solved by A. J. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/07/2018 - 07:42
Hi…Welcome to Got It Pro
User 02/07/2018 - 07:42
Hi there. Thanks for your assistance.
Excelchat Expert 02/07/2018 - 07:43
Could you please give a little more detail of your query?
Excelchat Expert 02/07/2018 - 07:43
May be with some sample data in this preview sheet.
User 02/07/2018 - 07:45
For example, in E1, I would like to include a formula where I can multiply the blank cells (B1 and D1) by 5 automatically. And this will give me 10. Am I able to do that with conditional formatting or the like?
User 02/07/2018 - 07:45
E1 = (number of blank cells x $5). Is there a formula for that in excel?
Excelchat Expert 02/07/2018 - 07:46
So you will like to count the number of blank cells and then multiply that result with $5, is that right?
User 02/07/2018 - 07:46
Yes that's right.
Excelchat Expert 02/07/2018 - 07:47
That can be done with a simple formula. No need of conditional formattting
Excelchat Expert 02/07/2018 - 07:47
Let me do the formula for you.
Excelchat Expert 02/07/2018 - 07:47
Should the count be from column A through D?
User 02/07/2018 - 07:48
Yes that's right because each time the result in column E will be different depending on the number of blanks each row has
Excelchat Expert 02/07/2018 - 07:49
Formula is =countblank(A1:D1)*5
User 02/07/2018 - 07:49
Ah I see. So I should use the formula "countblank"
Excelchat Expert 02/07/2018 - 07:49
Countblank is a function to count blank cells in a range
Excelchat Expert 02/07/2018 - 07:49
Excelchat Expert 02/07/2018 - 07:49
And then multiple with a the value
User 02/07/2018 - 07:49
That will be useful.
Excelchat Expert 02/07/2018 - 07:50
Your value of 5 can be variable if you use a cell reference.
Excelchat Expert 02/07/2018 - 07:50
Say instead of hard coded 5, if you have your value in Cell G1, then you can reference G1 and whenever you change G1 value, formula will automatically pick up.
Excelchat Expert 02/07/2018 - 07:51
Is there anything else I can help you with this query?
User 02/07/2018 - 07:51
Yes, I understand now. Thank you for your assistance. You have been very helpful. May I know how can I use this service again and what packages are there or the like?
User 02/07/2018 - 07:53
It's alright. I found information on that on your website. I will look through it. Thanks again for your help.
Excelchat Expert 02/07/2018 - 07:53
We are here 24X7 365 days to help you with all excel formula related queries.
User 02/07/2018 - 07:53
Sure. Thanks again. Have a good day.
Excelchat Expert 02/07/2018 - 07:53
Please do give me few feedback comments for my service at the exit of this session.
Excelchat Expert 02/07/2018 - 07:53
Thanks for your time. Please do come back for any new question. You can now end this session. Have a great day ahead!
User 02/07/2018 - 07:53
Sure. Bye. :)

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc