Change row colur

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
 
M

Mia

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


"Sam Wilson" skrev:
 
S

Sam Wilson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching in excel 2
Cell Selection Control 2
Insert rows at change in cell value 3
Automatic macro 5
Save as pdf with special name 4
Paste in column B using Last row of either column B, C or D. 10
Autofilter-sorting from specified cell 1
Excel Help to copy information from one row at a time to another sheet 1

Top