Need help with auto populating arrows-

[rawr19911]

so i have a spread sheet- (chart) that i am using and on there they are to show impacts- and the arrow needs to be either yellow purple based on what condition is met- and they need to be up down or left and right .. not sure how to write the macro for this or even how to start- was hoping someone could help.
the arrow are for - if its a customer impact it is purple if its employee its yellow-
if its a enhancement its up if its a disruption its down
if its a natural impact its left and right arror

the enhancment or disruption or nutural impact is in column C
the customer/employee impact is in column D

 

[portews]

Are you putting this in a table or on a chart?

If it's a table you can put this function in a module:

Function Arrows(ByVal state As Variant)

Select Case True
Case Application.WorksheetFunction.IsNumber(state) = False 'traps other than numbers
    Arrows = ""
Case state > 0
    Arrows = ChrW(&H21E7) ' up arrow
Case state = 0
    Arrows = ChrW(&H21E8) ' right arrow  &H21E6 for left arrow
Case state < 0
    Arrows = ChrW(&H21E9) ' down arrow
Case Else
    Arrows = ""
End Select

End Function

And then put this formula in the column you want the arrows in, pointing to the D column and fill the column.

=Arrows(D2)

You can then use Conditional Formatting based on the E column to get your yellow and purple.

 

[rawr19911]

Thanks! I will try this Monday and hope it works