Change row colur
 

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

Change row colur
 

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

Change row colur
 

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

Change row colur
 

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

Change row colur
 

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