Pulling cell formating through to new cell

excelbeginner1

New Member
Joined
Dec 13, 2014
Messages
9
Good day can anyone assist me , i am using the following formula to list my results.

=index(a$2:a$9,match(large(b$13:b$20,rows(a$13:a13)),b$13:b$20,false))
while this brings my value's through it does't bring the formating through.
I would like the cell fill also come through, as the values belong to different departments
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

JustynaMK

Well-known Member
Joined
Aug 28, 2016
Messages
630
Office Version
365, 2013
Platform
Windows
Hi,

Unfortunately it is not possible to do it with Excel formula - these can only retrieve values. You need to either manually apply the formatting (by using "Format Painter" or Ctrl+C > Paste Special > Formats), or use VBA code.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,505
Messages
5,469,013
Members
406,627
Latest member
IncandenzaH1997

This Week's Hot Topics

Top