hgbegdhegdh

New Member
Joined
Oct 17, 2019
Messages
17
Office Version
2010
Platform
Windows
I have below formula in one cell, lets take example A10
=VLOOKUP($A$2,'Port-3-Script'!$A$3:$DW$1992,95,FALSE)

in above formula it copies value from cell CE from Port-3-Script, as 95th column is mentioned in formula

Please help me in getting solution of below problem
1. I want along with values of CE it copies cell background color also in A10. How can I do that ?
2. After solving above Problem 1 how to copy only value and color (not formula) from A10 to another file, where VALUE and COLOR are can be pasted
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,849
Office Version
365
Platform
Windows
Neither of those are possible using formulae. A formula cannot see formatting.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,372
Messages
5,468,233
Members
406,574
Latest member
HeinrichPaul

This Week's Hot Topics

Top