RE: Show a row shaded when a cell contains certain data

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 spread*** 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