Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Change row colur

0 views
Skip to first unread message

Mia

unread,
Nov 23, 2009, 7:19:01 AM11/23/09
to
Hello,

I have a large spredsheet that I want to make easier to read.

In column B you can type in x or a. What I want is that if B15 changes to a
the whole row should became grey. This should be the case for the whole sheet.

Do anyone know how to do this?

BR
Mia


--
Best regards
Mia

Sam Wilson

unread,
Nov 23, 2009, 8:17:03 AM11/23/09
to
Look at conditional formatting in excel's help.

Sam

Mia

unread,
Nov 23, 2009, 9:14:02 AM11/23/09
to
I have tried that but I can´t find the right formula to make it work.
--
Best regards
Mia


"Sam Wilson" skrev:

Sam Wilson

unread,
Nov 23, 2009, 9:22:02 AM11/23/09
to
OK,

Highlight row 15, go to the conditional formatting wizard and choose
"Formula is" then type this as the formula:

=OR(($B15="x"),($B15="a"))

Then copy the row and paste special /formats where you want it to go.

Sam

Mia

unread,
Nov 24, 2009, 3:10:01 AM11/24/09
to
Thank you so much!!!

You solved my problem!!

0 new messages