Conditional Formatting

[Santurn]

I need help. I am looking for a formula to format Column A with shading based on a value found in Columns D, G and H. The value or text I am looking for is a "yes" in Columns D, G and H. Once that value is found I need the customer's name in Column A to be shaded. I have a formula, i.e., =D2:D25="Yes" (select format color), that works for one column but wanted to know if there is a nested formula I can use to attain the same result.

Any help is appreciated.

 

[T. Valko]

I modified the rule to pick up all of my rows and it's not working now. How do I pick up all 69 rows?

=OR(D2="yes",G2:H69="yes") I added the H69 and it didn't work.

You only want to do a row-by-row test so the formula has to be:

=OR(D2="yes",G2:H2="yes")

When you select the ENTIRE range B2:B10, then the formula will automatically adjust the references for each row.

For example, the formula to highlight cell B8 will automatically adjust to:

=OR(D8="yes",G8:H8="yes")

 

[Santurn]

Oooo, so there's no nested formula that can be created which would do cells B2 through and including H69?

 

[T. Valko]

Oooo, so there's no nested formula that can be created which would do cells B2 through and including H69?

Maybe I've misunderstood what you're trying to do.

Care to explain it again (in GREAT DETAIL).

 

[Santurn]

No, no, no. You were absolutely correct. I made a mistake.
Thank you for your wonderful answer and it does work beautifully.

Have a great weekend!! You've made mine.

 

[T. Valko]

No, no, no. You were absolutely correct. I made a mistake.
Thank you for your wonderful answer and it does work beautifully.

Have a great weekend!! You've made mine.

Ok, good deal. Thanks for the feedback!