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: https://docs.google.com/spreadsheets/d/1Bz2jHn_rQneb62QLuSGv46PdOv7V5SennmeL3vQcPbo/edit#gid=0

