conditional formatting--any years, all years, and an at least

Originally Posted by ammartino44

Actually, I didn't understand the third formula. =IF(ISERROR(MATCH(C8,C9:C5003)),IF(AND(COUNTIF(C:C,C8),COUNTIF(C:C,C8)-COUNTIFS(C:C,C8,E:E,">"&0)=0),"Yes","No"),"")

Why do you need the AND part? IT seems like you could delete that and just include this piece COUNTIF(C:C,C8)-COUNTIFS(C:C,C8,E:E,">"&0)=0)

Right... actually when I took a look at it again today, I have no idea why did I put that in

Originally Posted by ammartino44

Also, you need to put a FALSE in the formula or it doesn't work on larger spreadsheets.

Sorry, but which part may you be referring to?