Hi -- is it possible to do conditional formatting that would highlight the
first time a customer hits $1,000,000 or above and then in another column
look for those highlighted and place the year and qtr that happened


I have a pivot table that looks like this

column A Column B Column C Column D etc....
(2000-1 thru 2010-1)
Customer 2006-1 2006-2 2006-3
Customer A $1,000,500 $2,000,000
Customer B $1,000,000 $3,000,000

So I would want to highlight
Customer A the amt in 2006-2 and then create a column in my
spreadsheet that states 2006-2

Customer B highlight the amt in 2006-1 and in another column state 2006-1

Can anyone help?
Thank you!!!