Conditionally format the first cell in a column that matches criteria

Viewed 31
1 Answers

try:

=(INDEX(COUNTIFS(IF(A$2:A>=1000000, 1), IF(A2>=1000000, 1), 
  ROW(A$2:A), "<="&ROW(A2)))=1)*(A2>=1000000)

enter image description here

Related