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

Sorry Dave but you lost me. I tried it but it doesn't seem to work perhaps
if you could put it into idiots talk I may understand it a bit better.
Thanks
Steve

"Dave Peterson" wrote:

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

--

Dave Peterson

.

Loading