I have a 4 page worksheet and based upon the answers that are provided on page 1 I have set up conditional formatting on pages 2, 3, and 4 to highlight a cell if it meets the criteria from page 1. Now I need the highlighted cells to total at the bottom of each page on pages 2, 3, and 4. Is this possible?
Here is a sample scenario:
If M1324 is answered with a 1 on page 1 and it is an early episode with <13 therapy visits then a score of 3 would be highlighted on page 2.
=IF(AND('Page 1'!$H$11>=2,'Page 1'!$H$6="Early",'Page 1'!$H$29<=13),$D$42," ")
If M1334 is answered with a 2 on page 1 and it is a late episode with <13 therapy visits then a score of 8 would be highlighted on page 2.
=IF(AND('Page 1'!$H$16=2,'Page 1'!$H$6="Later",'Page 1'!$H$29<=13),$F$45," ")
Bookmarks