+ Reply to Thread
Results 1 to 4 of 4

Keeping the same format when using index

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    Lithuania, Klaipeda
    MS-Off Ver
    Excel 2013
    Posts
    96

    Keeping the same format when using index

    Is it possible using INDEX formula to keep the same format of the cell, especialy colours

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Keeping the same format when using index

    Hi, purlo,

    AFAIR any formula can only bring the result but not the Color/Font/Size.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    02-27-2014
    Location
    Lithuania, Klaipeda
    MS-Off Ver
    Excel 2013
    Posts
    96

    Re: Keeping the same format when using index

    even with VBA?

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Keeping the same format when using index

    Hi, purlo,

    why should anybody use VBA to bring back the result from INDEX? If the formatting is done by hand it can be done but I would recommend to use styles for the cells instead of hand-colouring all of these and apply the same style.

    Maybe attach a sample to explain what you are after and how things look before and after inclduing your INDEX (which should be the event to trigger the macro?)

    Ciao,
    Holger

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Keeping chart format
    By Panfergrrl18 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:25 AM
  2. Changing and keeping format
    By ecvariety in forum Excel General
    Replies: 2
    Last Post: 05-13-2013, 04:31 PM
  3. Excel 2007 : Vlookup! Keeping the format
    By Gl1234 in forum Excel General
    Replies: 1
    Last Post: 10-08-2011, 03:49 PM
  4. Keeping the same .txt format?
    By 843 in forum Excel General
    Replies: 0
    Last Post: 06-06-2007, 04:38 AM
  5. [SOLVED] keeping format
    By Maurice Samueks in forum Excel General
    Replies: 3
    Last Post: 03-16-2005, 02:06 PM

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