Dec 15 2020 05:18 PM
Dec 15 2020 10:38 PM
@Jwell1790 Easiest to demonstrate with some working examples. Please have a look at the attached file and see if it meets your requirement. In the first example (one row 1), the CF rule assumes the first number is in A1 and applies the formatting to the range A1:J1.
The second example is a bit more complicated as it will look for the first non-blank cell with a number in the entire row 5, to determine where-ever the first recorded value is on that row.
Both CF rules will skip empty cells in the ranges to be formatted.