I was comparing your sample data sheet to the conditional formatting codes you had attached earlier. I see that in the conditional formatting sheet, there are only 4 verticals, while the sample data shows 8. Also, which vertical corresponds to which name? For e.g. which vertical stands for Technology, which stands for Telecom should be specified.

I also see 2 Rev Types - however which is the Rev type for New From Base, is it Rev Type 1 or 2?

Once you sort out the above questions, i can work out the code for you.