Show a row shaded when a cell contains certain data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gadgetman - 02 Mar 2007 23:59 GMT

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

Reply to this Message

Dave Peterson - 03 Mar 2007 01:47 GMT

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

> 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

Signature

Dave Peterson

Reply to this Message

Gadgetman - 03 Mar 2007 14:22 GMT

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

> Select the range that should be affected (A:Z???)
> Then with the activecell in row #1
[quoted text clipped - 7 lines]
> > Thanks
> > Steve

Reply to this Message

Dave Peterson - 03 Mar 2007 16:12 GMT

Select all the columns you want formatted (select them all if you really meant
the entire row)

Notice that there's one white cell in that selection. That's the activecell.

Then follow those same instructions
format|conditional formatting
formula is
=$k1="T2"

and give it the format you want.

I'm not sure this helps. But you may want to explain what you don't understand
and what you did if it doesn't work.

> 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.
[quoted text clipped - 16 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 03 Mar 2007 16:18 GMT

Ps. Make sure that row 1 is visible when you do this--else the activecell may
not be row 1.

> Select all the columns you want formatted (select them all if you really meant
> the entire row)
[quoted text clipped - 35 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message

Elkar - 03 Mar 2007 03:14 GMT

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

> 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

Reply to this Message

Gadgetman - 03 Mar 2007 14:19 GMT

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

> Select column K
> From the Format Menu, choose "Conditional Formatting..."
[quoted text clipped - 10 lines]
> > Thanks
> > Steve

Reply to this Message