Conditional formatting in Multiple Sheet

[rizmomin]

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