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

's Computer Specifications

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.

's Computer Specifications

On 26/08/2010 17:04, Dave K wrote:
> 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.

Hi Dave,

You could put this in the worksheet's code module:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("$G$12").Address And _
Range("$G$12").Value ="yes" Then

Range("I12:W12").Interior.ColorIndex = 15

End If

End Sub

's Computer Specifications

On Aug 26, 11:21*am, ManicMiner17 <po...@noname.net> wrote:
> On 26/08/2010 17:04, Dave K wrote:
>
> > 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.
>
> Hi Dave,
>
> You could put this in the worksheet's code module:
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> * If Target.Address = Range("$G$12").Address And _
> Range("$G$12").Value ="yes" Then
>
> * * *Range("I12:W12").Interior.ColorIndex = 15
>
> * *End If
>
> End Sub

Thanks very much!

's Computer Specifications

Check your other post.

On 08/26/2010 11:04, Dave K wrote:
> 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 Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL	Dave K	Microsoft Excel Discussion	4	26th Aug 2010 06:12 PM
Referencing a named range based upon Range name entry in cell	=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=	Microsoft Excel Worksheet Functions	14	20th Jun 2007 07:19 PM
Highlighting Range of Cells based on another cell with 5 condition	=?Utf-8?B?QWxleA==?=	Microsoft Excel Programming	6	10th Nov 2006 06:45 AM
how do I apply 10% gray shade to a cell in Excel?	=?Utf-8?B?bXlyYWRkaW4=?=	Microsoft Excel Worksheet Functions	3	14th May 2006 06:48 AM
Gray shading within gray brackets - not highlighting or forms?	=?Utf-8?B?RWxpemFiZXRoIEdhcm5lcg==?=	Microsoft Word Document Management	2	5th Dec 2005 08:48 PM