Hello,

I am looking to conditionally format the first empty cell in each row.

In Column A, are different Account Numbers. In Columns B-F, there are different number values associated with each Account Number. Values in each row (i.e. for each Account Number) are filled left to right, without ever skipping a Column. I would like to highlight the first empty cell in each row (i.e. for each Account Number) yellow, as to designate what cell should be filled.

I have attached an example what the final product looks like in my head, but I am having trouble coming up with a formula that does this.

Workbook1.xlsx