software

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 YESHow do I do this?

One way:

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

CF1: Formula is =$G1=quot;YESquot;
Format1: lt;patternsgt;/lt;greygt;

In article gt;,
quot;Excel Challengedquot; lt;Excel gt; wrote:

gt; if cell g1=YES then I want the entire row (row1) to be shaded grey.
gt; if cell g1=blank or no then I want entire row (row1) to have no format
gt;
gt; example:
gt; A B C D E
gt; F G
gt; 1 4 01/01/06 Doe, John xxxx-xxxx Direct 529 Business
gt; $10,000.00 YES
gt;
gt;
gt; How do I do this?