Conditional formatting in Multiple Sheet

Hello:

Please refer to attached sheet.

I need to use same Conditional formating in multiple sheet.
In each of the sheet
if Cell B3="YES" then turn to Green
if Cell B3="NO" then turn to Red

I know little about conditional formatting, however i need help with doing the CF into multiple sheet.
The only have the knowledge to do CF in individual sheet.
This is really Pain when i have to do lots of sheet with same CF.

I don't mind if this can be done using VBA.

Please let me know if you have any questions.
Thanks.

Riz

Try the Format Painter, conditional formatting should get included...

Double click it twice to "keep" copying the format several times.

Hello AllKey:

Great Help...works
Thanks
Riz

Thank you for the rep!