Thread: Formula for IF a total goes to 3 pages do not have on 2nd page
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
texansgal texansgal is offline
external usenet poster
  
Posts: 34
Default Formula for IF a total goes to 3 pages do not have on 2nd page
I am going to attempt this. Thank you.

"PatrickA" wrote:

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