I want to set a conditional format such that
Cell B minus Cell A , if number is more than 15, cell B should turn red in colour. This should be for ALL cells in column B. How do I have it such that the difference between the 2 cells affect the conditional formatting, and this is translated down the rest of the cells in that column?
Then, I want it to be the same when Cell C minus Cell B, if number is more than 15, Cell C should turn red in colour. When Cell D minus Cell C, if number is more than 15, Cell D turns red in colour... etc.
Also, what should be the cells that are selected for the formula?