True if stock daily close price is >= 50% of daily High Low range.

Occasional Visitor

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.



0 Replies