HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL

[Dave K]

Hello, i am attempting to apply gray shading to the range i12:w12,
based on the cell g12. That is, if cell g12 contains the word "yes", i
want the cells i12 thru w12 to be highlighted gray.

Is there a simple way to accomplish that result?

Thanks for any suggestions.

 

[Dave K]

......i.e., is there a good formula to use via the "CONDITIONAL
FORMATTING" function.

 

[Dave K]

Hello, i am attempting to apply gray shading to the range i12:w12,
based on the cell g12. That is, if cell g12 contains the word "yes", i
want the cells i12 thru w12 to be highlighted gray.

Is there a simple way to accomplish that result?

Thanks for any suggestions.

....i.e., is there a good formula to use via the "CONDITIONAL
FORMATTING" option.

 

[Dave Peterson]

Select the range and use:

=$g$12="yes"
(if contains means equals)

If contains means that there could be more stuff along with "yes":
=countif($g$12,"*yes*")>0

=countif() will use those asterisks as wild cards.

 

[Dave K]

Select the range and use:

=$g$12="yes"
(if contains means equals)

If contains means that there could be more stuff along with "yes":
=countif($g$12,"*yes*")>0

=countif() will use those asterisks as wild cards.

Great. thanks a million!