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

  • Thread starter Thread starter Dave K
  • Start date Start date
D

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.
 
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.
Click to expand...

....i.e., is there a good formula to use via the "CONDITIONAL
FORMATTING" option.
 
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.
 
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.
Click to expand...

Great. thanks a million!
 
Back
Top