Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Excel 2003 in XP:
I want to copy the formatting of one of 12 cells whose location I have calculated. I could use the usual Conditional Formatting, but that only gives 3 options. I need 12. to wit: I want to copy the formatting of a cell in a row above the cell to be formatted. In a cell to the left I have calculated how many columns of offset to the desired format to be copied. The cell format I want to use is in a row above my cell, and offset by 0 to 11 cells. Any ideas? - Thanks! -- sdm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting a calculated value in a cell | Excel Discussion (Misc queries) | |||
Cell Referencing problem when copying conditional formatting | Excel Discussion (Misc queries) | |||
Formatting numbers in each cell after I have calculated their valu | Excel Worksheet Functions | |||
Copying cell formatting when selecting from a list | Excel Discussion (Misc queries) | |||
Copying color formatting from cell to cell | Excel Discussion (Misc queries) |