Select the range that should be affected (A:Z???)
Then with the activecell in row #1
Format|conditional formatting
Formula is:
=$k1="T2"
and give it a nice format

Gadgetman wrote:

I have a spreadsheet which if column K has the data 'T2' in it I want the
whole row to be shaded red. Can anyone explain how to do this?
Thanks
Steve

--

Dave Peterson