• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlighting cells in a column from the differences of other cells

P

pucha

Member
Highlighting cells in a column from the differences of other cells.

Sir i am not able to highlight few cells in column from a difference of other cells. I have uploaded a file for your understanding. Kindly check the file.
 

Attachments

  • ABC.xlsx
    9.3 KB · Views: 8
pucha
Do You mean
(1) if 29 <= 23 then 'something'
(2) if 29 >= 23 then 'something'
Would You show that 'something' as a sample result?
 
pucha
Your sample results shows that ...
You would like to ... hmm? ...
... Highlighting cells like K5 & K10
... amazing?
Really??
 
Yes, I used this formula in conditional formatting [=AND(ABS($G$4-$F$4)<=ABS($F$4-$H$4))] and this [=AND(ABS($G$4-$F$4)>=ABS($F$4-$H$4))] for getting the result I want but it shade the whole range c5:c53 into a single color.
Yes K5 & K10 are the formulas that I want to Highlight.

Thanks
 
1) Highlighting cells like K5 & K10 - okay
2) but there were no other 'Highlighting cells' with any color!
= no needed sample result!
3) Your original case was:
Highlighting cells in a column from the differences of other cells.
There were one word in cell E1
... do You want to use ONLY something like that?
If so .. then good luck
other way .. I would continue,
but not before, I'll know which way?
 
Simply, this is a stock oriented showcase where open/high/low/close are given and a range of c5 to c53. You will find the values of open/high/low/close all are in the range c5 to c53.

I just want to make a stock candlestick over this range. if high-open is less than open-low the the price is falling and when high-open is greater than open-low the price is rising. so when falling it will be red in color and when rising it will be green in color. This is the simple technique

I want to show over the range c5 to c53.
 
pucha
Hmm...?
I tried to ask questions,
which would be possible to answer - but no!
No sample results nor which way?
Seems, that You don't know answers...
I won't even try to guess.
 
Is this the sort of thing you are looking for?
See the defined Name rising?
= (high-open) >= (open-low)

Note 1. the buttons have been added simply to test the two cases.
Note 2. The prices do not appear to tie up with the high/lows.
 

Attachments

  • Stock price movement.xlsx
    22.7 KB · Views: 6
You must log in or register to reply here.
Back
Top