Show a row shaded when a cell contains certain data
Thanks it did work but only in the K cell. What I need is for it to high the
whole row in the same shade.
Thanks
Steve
"Elkar" wrote:
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
|