Change row colur

  • Thread starter Thread starter Mia
  • Start date Start date
M

Mia

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
 
I have tried that but I can´t find the right formula to make it work.
--
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
 
Back
Top