Thanks in advance for any help!!
I have the open, high, low, and close data and trying to return a conditional color fill, if the stock closed in the upper 50% green, lower 50% orange.
I've figured out how to arrive at the percentage by summing the high - low & high - close then dividing 2nd equation by first. I'm using basic formulas that take up additional cells. I was hoping to just return the condition without adding more cells but haven't figured that out yet.
Appreciate any and all help and/or advice.
Thanks
