Change row colur

's Computer Specifications

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

's Computer Specifications

Look at conditional formatting in excel's help.

Sam

"Mia" wrote:

> 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

's Computer Specifications

I have tried that but I can´t find the right formula to make it work.
--
Best regards
Mia

"Sam Wilson" skrev:

> Look at conditional formatting in excel's help.
>
> Sam
>
>
> "Mia" wrote:
>
> > 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

's Computer Specifications

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" wrote:

> I have tried that but I can´t find the right formula to make it work.
> --
> Best regards
> Mia
>
>
> "Sam Wilson" skrev:
>
> > Look at conditional formatting in excel's help.
> >
> > Sam
> >
> >
> > "Mia" wrote:
> >
> > > 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

's Computer Specifications

Thank you so much!!!

You solved my problem!!

--
Best regards
Mia

"Sam Wilson" skrev:

> 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" wrote:
>
> > I have tried that but I can´t find the right formula to make it work.
> > --
> > Best regards
> > Mia
> >
> >
> > "Sam Wilson" skrev:
> >
> > > Look at conditional formatting in excel's help.
> > >
> > > Sam
> > >
> > >
> > > "Mia" wrote:
> > >
> > > > 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mixed colur text.	Chris Watts	Microsoft Excel Discussion	4	5th Jun 2010 07:19 AM
Change colur of single column in chart	Chris Watts	Microsoft Excel Discussion	4	1st Oct 2009 07:30 PM
sum numbers of a different colur in a row of data	=?Utf-8?B?cGplbno=?=	Microsoft Excel Worksheet Functions	4	14th Sep 2007 09:46 PM
No colur on my tv from my laptop	=?Utf-8?B?QmliYmll?=	Windows XP Video	0	28th Dec 2003 08:11 PM
Tv-out, no colur	=?Utf-8?B?VG9tbXk=?=	Windows XP Help	1	28th Dec 2003 07:33 PM