Macro issues with VB code

jaipurhandsome

New Member
Joined
Aug 6, 2013
Messages
5
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
5. Count groups falling into #3
6. Count groups falling into #4
7. Save as EXCEL Workbook

<TBODY>
</TBODY>

<TBODY>
</TBODY>
 
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.
 
Upvote 0

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,216,119
Messages
6,128,946
Members
449,480
Latest member
yesitisasport

We've detected that you are using an adblocker.

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.
Go back
Back
Top