Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change formula based on color
I have to copy a worksheet into another file and I can't
seem to drop the reference of the worksheet I copy in from the file it came from. It only applies to cells with a certain color that have a formula that looks at other workbooks. I have to do this for many files and I was hoping maybe someone has some sample code that would change the formula in a cell to make to look at other worksheets in its own workbook based on a certain cell color. Any help would be appreciated, thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
Auto change background of color based on formula | Excel Worksheet Functions | |||
How do I change color pattern based upon a formula within a cell? | Excel Worksheet Functions | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) |