Select column K
From the Format Menu, choose "Conditional Formatting..."
Change "Cell Value Is" to "Formula Is"
Enter the formula: =COUNTIF(K:K,"T2")0
Choose your format
OK

HTH,
Elkar


"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