Results 1 to 4 of 4

Formula extension, need to include cell color transfer

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    34

    Formula extension, need to include cell color transfer

    Hi guys

    I've made a index-match formula. In my excel sheet in document 2 the function searches for values in document 1 and makes an output that is a corresponding horizontal value. See attached excel document.
    However, I would like the formula to be extended. So it also transfers the cell color, i.e not only does the index-match function find the corresponding number, it also transfers the color of the cell (if it is colored ofc).

    I used the following formula already for the index-match; =IFERROR(INDEX([1.xlsx]Ark1!$A$2:$A$11;MATCH(A6;[1.xlsx]Ark1!$B$2:$B$11;0));"")


    Hope you guys can help me with the colortransfer.

    Thanks in advance.

    Christopher
    Attached Files Attached Files
    Last edited by ChristopherH; 01-06-2013 at 02:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1