Conditional Formatting

  • Thread starter Thread starter H
  • Start date Start date
H

H

I am wondering if there is a way to highlight in Conditional Formatting when
a Customer 1st hits 1M mark

My data is in a pivot table that looks like


Customer Name Yr2000Qtr1 Yr2000Qtr2 etc .. on up to
Yr2010Qtr1
Customer A $1,000,000 $50,000
Customer B $90,000 $1,500,000 $2,000,000

I would want to highlight Customer A and the amt in YR2000Qtr1
and Customer B Yr2000Qtr2 amt but not the next one (Only the 1st
time they hit it.
 
format-Conditional format.
Formula is:
=AND(B2>=1000000,COUNTIF($A2:A2,">=1000000")=0)

Choose desired format.
Copy formatting across and down as needed.
 
Thank you, I tried
=AND(B6>=1000000,COUNTIF($A3:A3,">=1000000")=0)

but it's still highlighting the other columns when it goes over a $1m and
I'm hoping for it to only highlight the 1st time it goes over?
 
All parts of the formula need to refer to the same row. So, if you are
formatting cell B6, formula is:

=AND(B6>=1000000,COUNTIF($A6:A6,">=1000000")=0)

or, for clarity:
=AND(B6>=1000000,COUNTIF($B6:B6,">=1000000")=1)
 
Back
Top