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