Conditional Formatting (97)

Topic

New Reply

Hi all
How can I make a Roll change color if a Cell says Yes
I want Rolls A2, A3, A6, and A7 or from A to E to be gray is cell E contains the word Yes
I know its conditional formatting but I don

Reply | Quote

Replies

Select A2:d8
Format – conditional formatting
Formula is
=UPPER($D2)=”YES”
Format button – patterns to gray

Steve

Reply | Quote

Steve,
Very interesting solution. Would you mind explaining how ir works?
Thanks,
Jeff

Reply | Quote

Cond format works when the formula is “TRUE”

The formula given:

=UPPER($D2)="YES" 

is TRUE when the UPPERcase value in the D column (note it is LOCKED on Col D) in the RELATIVE row = “YES”

I used Upper to allow “yes”, “Yes”, “YES”, “yEs”, etc as all possible “Yes” responses.

You could have easily put:

=$D2="yes" 

But ONLY “yes” rows would have highlighted, not any variant.

Steve

Reply | Quote

Thanks, Steve.

Reply | Quote