Highlight cells with values >= to an amount

[Deutz]

Hi and thanks in advance,

I have a column on a sheet which contains year-to-date amounts (in ascending order) and I would like to use conditional formatting to highlight the first value in that column >= 1000, >= 2000, >= 3000 and so on, up to >= 9000. I have tried quite a number of formulas but still not sure how to achieve it. I would like to achieve it without array formulas if possible.

Year to date amounts	Criteria met
997
999
1000	First value >= 1000
1000
1002
2007	First value >= 2000
2009
3024	First value >= 3000
4006	First value >= 4000

Thanks
Deutz

 

[Sufiyan97]

Try the formula in conditional formatting
assuming values start from A2

=IF(OR(COUNTIF($A$2:A2,">=1000")=1,COUNTIF($A$2:A2,">=2000")=1,COUNTIF($A$2:A2,">=3000")=1,COUNTIF($A$2:A2,">=4000")=1),TRUE,FALSE)

 

[Deutz]

Try the formula in conditional formatting
assuming values start from A2

=IF(OR(COUNTIF($A$2:A2,">=1000")=1,COUNTIF($A$2:A2,">=2000")=1,COUNTIF($A$2:A2,">=3000")=1,COUNTIF($A$2:A2,">=4000")=1),TRUE,FALSE)

Thanks Sufiyan97, that works really well!!! Much appreciated !!!

 

[Sufiyan97]

You're welcome!

 

[Sufiyan97]

Just remembered

You don't need IF with OR, you can jus use

=OR(COUNTIF($A$2:A2,">=1000")=1,COUNTIF($A$2:A2,">=2000")=1,COUNTIF($A$2:A2,">=3000")=1,COUNTIF($A$2:A2,">=4000")=1)