Coping Cell Data using Vlookup

[Duhaine]

I currently have two worksheets within the same workbook

One is a pure data sheet which is colour coded and the second is the primary worksheet with all the my vlookup formula's on it.

When using the vlookup formula i can get the information that i am looking for from the data sheet and it works perfectly. but it only brings over the cell values.

But the cells in the data sheet have a background colour coded and also a font colour coded.

how can i get this background and font color information copied into the primary worksheet from the data sheet

have been at this a few hours and am getting nowhere fast

Any help would be greatly appreicated

[WinteE]

Hi,

It's maybe a possibility to use conditional format, supposing you need a specific format when VLOOKUP() returns a value.

Erik

[martindwilson]

it can be done via vba! using match