Conditioning A Whole Row, Based On The Content Of A Single Cell.

[Emmily]

Hi All.

Re: Conditioning A Whole Row, Based On The Content Of A Single Cell.


I'm a little new to Excel, so apologies if this should be posted in a more Newbie orientated forum.

I have a basic spreadsheet. 40 rows long and 8 columns wide. Column 8 (the last column) contains only a single word. Depending on what that word is, I want that entire row (columns 1 - 8) to turn into a grey colour. So far, I can only figure out how to get an invidual cell to change colour.

Kind Regards
Emmily

[mrice]

Paste the following code into the appropriate sheet tab (probably Sheet1) in the VBA editor (hit Alt F11 to see this)

Please Login or Register  to view this content.

Change the list of trigger words in column 8 as you wish remembering to include the quotes as in the example.