Good morning, i have a situation where i have a conditional format to do a
traffic light, but i want to use the same data to manipulate arrows in the
adjacent cell, this will point up when red, right when green and left when
Amber.

Can this be done? How do i do that if it is possible?