Add border & apply conditional formatting to sheets based on cell value

[amar05]

Hi all,
I have a macro that applies borders and conditional formatting to a sheet based on a cell value. The Workbook has 20+ worksheets and the sheet names may change. I am looking for a macro that will apply the below code it to all worksheets except for 'Sheet1', 'Sheet2' and 'Sheet3'.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I believe that the code I am looking for, has to start w/

Please Login or Register  to view this content.

but I don't know how to adjust the above code.

Any help is much appreciated.

Thanks

[jaslake]

Hi amar05

Probably something like this

Please Login or Register  to view this content.

[amar05]

Hi John,
The code worked, but how can I integrate this part:

Please Login or Register  to view this content.

It has to check cell A3 in all the sheets (except for sheet1, sheet2 and sheet3) for any values before adding the rows & cond. formatting.

Thank you.

[jaslake]

Hi amar05

Your doing a lot of selecting which probably isn't necessary but try this (untested)

Please Login or Register  to view this content.

[amar05]

Worked perfectly. That's what I was looking for.

Thanks so much for your help.

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.