Hello All
I have a list of 100000 numbers ordered in an ascending column
I am trying to write a formula to highlight via conditional formatting every cell (or row containing that cell) where the numerical value is x (the starting number in the ordered sequence) plus n (a value that could be changed).
So successive highlighted cells/rows are n higher than the last highlighted cell.
Please see the attached example1.xls where I can achieve this for the first value of X shown (2414.44) (here cell C7)
If I take n=12
then the conditional formatting formula working off the cells containing a range of x+12 and x+13 (respectively cells F7 & G7) correctly highlights the next values in the x+12 range (2426.43 & 2426.87, cells C34 & C35) in red.
However, when I try and 'drag and extend' the formatting I cannot make the formula relatively reference successive x+12 and x+13 cells (for example as shown, cells F34 & G34).
Any help to achieve this would be appreciated - the real number list to be analysed is 100000 long and so a laborious manual task otherwise.
Thanks in advance
KB
Bookmarks