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
|