Created by David Hager
To make a conditional format based on the value in the previous
worksheet, create the following defined name formulas.
which gives the value from the cell it is used in.
which gives the value from the cell of the same address in the previous
Then, combine these in yet another defined name formula.
GTPSV (this cell value is greater than previous sheet value) as:
which is used as the conditional formatting formula (in Excel 97 and later
Editor’s Note: The value on the sheet to the left, in my test, is zero (i.e., less than two).