I'm back asking more questions on conditional formatting.
As some of you that have assisted me in the will know, I currently trade stocks on the NYSE. I seek help identifying a money making pattern using Excel.
Just as a FYI the pattern is called a Double Bottom. Its used by traders to help identify a change in trend - I have attached an illustration of the pattern for those that may be interested. I have also attached the spreadsheet where I looking to use with the conditional format.
OK, a) I'm seeking help compiling a conditional format what will find where two prices are the same, between two points. For example, you will see E2 has a value of 88.53 and DL2 also has a value of 88.53. This would satisfy the first condition.
b) On day fourteen, I would like the value in Cell BE2 to be greater than the cell E2(88.53) by 15%
That would satisfy the second condition.
c) I would like cell DP2 to be greater than DH2 and DV2 to be greater than DP2. That would satisfy the third condition.
If all conditions are met I would like a highlight in cell A2.
Need-less-to-say, I would like the condition replicated through out the spreadsheet.
I have received help with the third condition in the past, so hopefully that shouldn't prove to tricky for you Excel gurus.
I have tried to explain myself in as much detail as possible, but let me know if you need further clarification.
As always, thanks in advance for your help.