conditional format rows
 

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?

conditional format rows
 

One way:

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

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

In article ,
"Excel Challenged" <Excel wrote:

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?