Conditional Formatting for Multiple Worksheets

[alyaahmed]

Hello,

I am having an excel workbook consisting of 11 sheets. Can I apply conditional formatting to multiple sheets at the same time? If there is a way, I would be grateful if you could guide me how to do it.

Regards,

Alya

[mehmetcik]

Selam Alya

The attached file has a macro.

Sheet one comes with a conditional format that makes the row Red if 60 days have elapsed since the date in column A

Sheet one has no formatting.

Clicking on the button will fill every sheet in the workbook with the same conditional format.

There is a start for you.

Please Login or Register  to view this content.

[alyaahmed]

Thanks a lot mr mehmetcik for your response.