Is it possible using INDEX formula to keep the same format of the cell, especialy colours
Is it possible using INDEX formula to keep the same format of the cell, especialy colours
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
even with VBA?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks