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
=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