Color Cell

[pranamu]

Hi Expertise,

I want a help to color a cell. If 4 columns in a row are having checkbox and all of them are checked then a cell should be colored 100% otherwise based on the number of check box checked. Please help providing formula or any other tips.

Thanks,
Prakash

 

[Joe4]

a cell should be colored 100%

That really doesn't make sense. It seems that you are mixing two different things/concepts together.
Do you want it to return "100%" (which would be a formula)?
Or do you want it displayed a certain color (which would be conditional formatting)?

And exactly what kind of checkboxes are these?
How where they created?
Are they form controls or ActiveX objects?

 

[pranamu]

That really doesn't make sense. It seems that you are mixing two different things/concepts together.
Do you want it to return "100%" (which would be a formula)?
Or do you want it displayed a certain color (which would be conditional formatting)?

And exactly what kind of checkboxes are these?
How where they created?
Are they form controls or ActiveX objects?

The checkbox is from Form Controls. I had seen below formula somewhere, after entering it cell is colored if 4 boxes are checked otherwise color portion is as per selection count. I tried applying same formula but it didn't turned out.

I just need cell to be colored as per box cheked. Thanks Joe4

 

[Joe4]

I have never used Sparklines before, but I found the following article.
Please refer to this article on creating sparklines: Excel Sparklines - A Complete Guide with Examples

However, there may also be another issue at play here. In order to use the COUNTIF formula on Form controls, you first needs to map the values of the checkboxes to specific cells (it does not happen automatically). This article here shows you how you can do that: How to Count Checkboxes in Microsoft Excel.