conditional format rows

E

Excel Challenged

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?
 
J

JE McGimpsey

One way:

Select the entire row 1. Choose Format/Conditional Formatting...

CF1: Formula is =$G1="YES"
Format1: <patterns>/<grey>
 
Top