AndersNOR9
New Member
- Joined
- Nov 13, 2017
- Messages
- 20
Hi,
In column F i have cells filled with shapes. Rectangle 1, 2 etc. In E I have either the text RED, Orange or Green. The text string is made of this formula:
=IF(HR!J7>HR!E7;"GREEN";IF(AND(HR!J7<HR!E7;(0,8*HR!E7<HR!J7));"ORANGE";"RED"))
I want the shape inF to be filled with color according to the text string in E. Is there any easy way to do this?
https://pasteboard.co/GXRfgfAo.png
In column F i have cells filled with shapes. Rectangle 1, 2 etc. In E I have either the text RED, Orange or Green. The text string is made of this formula:
=IF(HR!J7>HR!E7;"GREEN";IF(AND(HR!J7<HR!E7;(0,8*HR!E7<HR!J7));"ORANGE";"RED"))
I want the shape inF to be filled with color according to the text string in E. Is there any easy way to do this?
