Conditionally format the first cell in a column that matches criteria-CodePudding

Home > Blockchain > Conditionally format the first cell in a column that matches criteria

Conditionally format the first cell in a column that matches criteria

Time：08-16

I would like to conditionally format the first instance in a column where the value matches the criteria (in the example below >= 1000000).

Here is an example spreadsheet:

CodePudding user response：

try:

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