• 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.

To find a range

T

Techtrend

Member
Hello Team


Need Help fixing a range based Band

Please check the attached sample.


1) The B is the Current price ,

If the B values are same or higher then G values its a buy and the color in the B has to be highlighted to green ,If the B values are same or lesser then I values then its a sell and has to be highlighted with red


and K to T is all Targets where the range will be formed


for Ex

1) B2 is higher then G2 which is green and then it falls in the range K2 and L2 which also has to be highlighted to green

2) B3 Is lesser or same as I3 and its sell ,The I2 has to highlighted to red and its in p3 and q3 range



Range is bcaz we may not get exact values


Please let me know if any more clarification required.
Narendra Kumar
 

Attachments

Hi Narendra ,

I have done the CF for the BUY section ; can you see if it is correct , and if it is , then replicate it for the SELL section ?

Narayan
 

Attachments

Hi Narendra ,

On the Home tab , click on Conditional Formatting and then Manage Rules.

Change the selection in the dropdown from

Current Selection

to

This Worksheet

Narayan
 
Buy works fine : If B2 is higher the G2 gets highlighted green With its target ranging from K-O,which is also getting highlighted.

The same happens in the Sell Side

Problem to be fixed for sell : If B2 is Lower then I2 ,The I2 gets highlighted to Red With its target ranging from P-T,which also has to get highlighted.

Narendra
 
Hi Narendra ,

Can you explain in greater detail the rules for formatting the columns P through T ?

If B2 is between Q2 and R2 ?

If B2 is between P2 and Q2 ?

I believe column I is already being shaded correctly ?

Narayan
 
Mr.Narayan

Please check the attached sheet,

For Ex the B2 Current price is 1800,The G2 Gets highlighted and also T2 and T3 Gets highlighted as 1800 is in this range.

Now for the Sell

If the price of B2 is 1700 The G2 and K - O will not be activated ,
The I2 has to be highlighted as the price of B2 is lower then I2,
and R2 and S2 gets highlighted as 1700 is in this range ,
for the Sell side the range will be P-T.

Reason for this formula : The Sheet is live and the values in B will be changing,
and accordingly we need to highlight the Buy or Sell and its Targets.

Hope i am clear,Let me know if more clarification needed
NArendra
 

Attachments

Mr.Narayan

I applied the range to my sheet,
Not working properly might be some issue from my end,

Can you please fix it in this sheet HL-BO the range

Narendra
 

Attachments

You must log in or register to reply here.
Back
Top