| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function to extract background color from one cell to another
Hi all,
Doe's anyone know if a function/addin etc exists that will enable me to get the background color from a cell and then copy it to the current cell eg someting like in sheet 1 cell A put the formula =backgroundcolor(sheet2! A1) then replicate to other cells I can't use the normal method of copy/paste special as I need to do it for a LOT of cells Lotus 123 used to have an addin called @setstyle ....I'm after something similar Thanks to all who have helped me on previous posts.....even if you didn't know you had ! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200603/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to select second-to-last non-empty cell | Excel Worksheet Functions | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
Threaded Mode
