AndreaM
08-21-2017, 03:47 AM
Hi,
I need assistance and haven't been able to figure it out. I am trying to do conditional formatting via VBA because I need the formula to do a lookup from a variable of a Cell but cannot use relative references. Basically I want to use Icon Sets using a formula when the value is > than and the >=. I would like the formula to do a lookup from Column A to match a value in Column A from another Sheet and then return the value from a cell in Column D from the lookup.
Sheet 1
A
B
C
1
ADDSURE
800
350
2
FRUITONE
300
900
3
HHO
400
700
Sheet 2
A
D
F
3
ADDSURE
850
350
7
FRUITONE
300
850
12
HHO
400
700
I would like All values in Column B and C to show an up Arrow or Down Arrow if the Values from Sheet 2 Column D and F are > than or = to the Values in Sheet 1.
Kind regards
Andrea
I need assistance and haven't been able to figure it out. I am trying to do conditional formatting via VBA because I need the formula to do a lookup from a variable of a Cell but cannot use relative references. Basically I want to use Icon Sets using a formula when the value is > than and the >=. I would like the formula to do a lookup from Column A to match a value in Column A from another Sheet and then return the value from a cell in Column D from the lookup.
Sheet 1
A
B
C
1
ADDSURE
800
350
2
FRUITONE
300
900
3
HHO
400
700
Sheet 2
A
D
F
3
ADDSURE
850
350
7
FRUITONE
300
850
12
HHO
400
700
I would like All values in Column B and C to show an up Arrow or Down Arrow if the Values from Sheet 2 Column D and F are > than or = to the Values in Sheet 1.
Kind regards
Andrea