1. i want to Create a border around items with row 1(name) (do not look at size-number after last dash) and same item title.how please write code if cell
2. Highlght in yellow group of items (row1+ row2) where some status is 100% not linked and available of atleast 1 row is >0
4. Highlght in orange any row with in a Group where 4th row status = not linked and available is >0, but others within the group are linked
I have all the code there that does, that you just have to edit the conditions in which they are coloured. I don't full understand what conditions need to be met, but the code is there so just alter the IF statements that colour the boxes and it will work. And I also added a link that shows you how to count the coloured boxes.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.