Thread: Formula for IF a total goes to 3 pages do not have on 2nd page
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PatrickA PatrickA is offline
external usenet poster
  
Posts: 5
Default Formula for IF a total goes to 3 pages do not have on 2nd page
You could also compare the numbers in the TOTAL field on P2 and the
TOTAL field on P3, and using conditional formatting,

on P3, if they are =, "white out" the TOTAL
on P2, if TOTALp2<TOTALp3, "white out" the TOTAL
Reply With QuoteReply With Quote