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
Bookmarks