lillian
Board Regular
- Joined
- Oct 12, 2005
- Messages
- 72
after digging around the web, I came across a method from the J-walk.com eee newsletter that looks promising - but I can't get it to work:
----------------------------------
http://j-walk.com/ss/excel/eee/eee003.txt (halfway down the page)
Created by David Hager
----------------------------------
To make a conditional format based on the value in the previous
worksheet, create the following defined name formulas.
GlobRef as:
=INDIRECT("rc",FALSE)
which gives the value from the cell it is used in.
PrevShtValue as:
=INDIRECT(INDEX(GET.WORKBOOK(1),GET.DOCUMENT(87)-1)&"!"&ADDRESS(ROW(),
COLUMN()))
which gives the value from the cell of the same address in the previous
sheet.
Then, combine these in yet another defined name formula.
GTPSV (this cell value is greater than previous sheet value) as:
=GlobRef>PrevShtValue
which is used as the conditional formatting formula (in Excel 97 and later
versions).
----------------------------------
Has anyone used this or can anyone speak to the details of how to use this?
Cheers!
----------------------------------
http://j-walk.com/ss/excel/eee/eee003.txt (halfway down the page)
Created by David Hager
----------------------------------
To make a conditional format based on the value in the previous
worksheet, create the following defined name formulas.
GlobRef as:
=INDIRECT("rc",FALSE)
which gives the value from the cell it is used in.
PrevShtValue as:
=INDIRECT(INDEX(GET.WORKBOOK(1),GET.DOCUMENT(87)-1)&"!"&ADDRESS(ROW(),
COLUMN()))
which gives the value from the cell of the same address in the previous
sheet.
Then, combine these in yet another defined name formula.
GTPSV (this cell value is greater than previous sheet value) as:
=GlobRef>PrevShtValue
which is used as the conditional formatting formula (in Excel 97 and later
versions).
----------------------------------
Has anyone used this or can anyone speak to the details of how to use this?
Cheers!