| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum numbers of a different colur in a row of data | Excel Worksheet Functions | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Change conditional formatting to coloured alternate rows dependent on a change in date? | Excel Programming | |||
| No colur in normal view but is in print preview | Excel Discussion (Misc queries) | |||
| Macro to colur tabs based on cel value | Excel Programming | |||
Hybrid Mode
