if cell g1=YES then I want the entire row (row1) to be shaded grey.
if cell g1=blank or no then I want entire row (row1) to have no format

example:
A B C D E
F G
1 4 01/01/06 Doe, John xxxx-xxxx Direct 529 Business
$10,000.00 YES


How do I do this?