Excel Formula - IF Formula & Conditional Formatting

[rhhince]

I am working on a formula to do candlestick charting manually.
I have a number in cell A1. I want to compare that number to 4 number
in 4 colummns OPEN HIGH LOW CLOSE. If the number is between or equal t
the OPEN and CLOSE, I want a color representing that; Green if th
CLOSE was higher than the OPEN, Pink if the CLOSE was lower than th
OPEN, Black for every cell that is between or equal to the HIGH an
LOW. Basically, it's a formula that if the value is TRUE than any on
of the 3 conditions will be applied, if FALSE it remains empty. I
there a mathematician in the house? I would appreciate your help
Thanks

 

[JE McGimpsey]

I think you need to work on your explanation a bit:

first you stipulate a number in cell A1, then you talk about "black for
every cell that is between...". What cells "between" are you referring
to?

Also, if the close was higher than the open, should "it" be Green (CLOSE
was higher than the OPEN) or Black (every cell that isbetween or equal
to the HIGH and LOW)?

When would "it" be FALSE?