Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cell plus adjoining cell
Hi, i am trying to figure out how to format a cells based on the value of
another cell, F66. I have a spreadsheet with 7 lists of clients with at various locations on the spreadsheet and a matching credit score next to them. I wish to format the cell in the list equivelant to the value of F66 and the adjacent cell with an outline heavy border round the two cells. I can conditional format for one cell but not the two. Any ideas would be greatly appreciated. Davie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cell plus adjoining cell
Use pastespecial and use formats.
Selection.PasteSpecial Paste:=xlPasteFormats "davethewelder" wrote: Hi, i am trying to figure out how to format a cells based on the value of another cell, F66. I have a spreadsheet with 7 lists of clients with at various locations on the spreadsheet and a matching credit score next to them. I wish to format the cell in the list equivelant to the value of F66 and the adjacent cell with an outline heavy border round the two cells. I can conditional format for one cell but not the two. Any ideas would be greatly appreciated. Davie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cell plus adjoining cell
Joel, if the condition is true for A5 I want the border to cover A5:B5. The
additional cell will always be to the right of the conditional cell. There are no cells with the border already created to copy. Also I have two conditional formats already on the spreadsheet. It is the code to reference the two cells I am trying to find. Davie "Joel" wrote: Use pastespecial and use formats. Selection.PasteSpecial Paste:=xlPasteFormats "davethewelder" wrote: Hi, i am trying to figure out how to format a cells based on the value of another cell, F66. I have a spreadsheet with 7 lists of clients with at various locations on the spreadsheet and a matching credit score next to them. I wish to format the cell in the list equivelant to the value of F66 and the adjacent cell with an outline heavy border round the two cells. I can conditional format for one cell but not the two. Any ideas would be greatly appreciated. Davie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop spilling the text to the adjoining cell | Excel Discussion (Misc queries) | |||
If blank, insert adjoining cell value | Excel Programming | |||
automatically date a cell when entering data in adjoining cell | Excel Programming | |||
How can I match up values from 2 sheets and info in adjoining cell | Excel Discussion (Misc queries) | |||
How do I display contents of an adjoining cell? | Excel Worksheet Functions |