CCkfm2000
06-10-2005, 09:34 AM
:banghead: Hi all.....
I have some data in sheet 2 with cell
a1 = 1
a2 = 2
a3 = 3
a4= 4
...... and so on
then in cell
b1 = D
b2 = N
b3 = DS
b4 = NS
... and so on
over 1000 lines.
In sheet 1 cell (b1) i do a =VLOOKUP(A1,Sheet2!A1:B4,2,FALSE)
What i need is the cell b1 formatted in different colours. Eg. D = blue . N = red , DS = Yellow , NS = green.
I've found some code that i've tried it works if i type in d or n but not when i do the vlookup.
Please help
:hi:
I have some data in sheet 2 with cell
a1 = 1
a2 = 2
a3 = 3
a4= 4
...... and so on
then in cell
b1 = D
b2 = N
b3 = DS
b4 = NS
... and so on
over 1000 lines.
In sheet 1 cell (b1) i do a =VLOOKUP(A1,Sheet2!A1:B4,2,FALSE)
What i need is the cell b1 formatted in different colours. Eg. D = blue . N = red , DS = Yellow , NS = green.
I've found some code that i've tried it works if i type in d or n but not when i do the vlookup.
Please help
:hi: