On the attached, I want to highlight green the latest entry in a row of cells (reading left to right)
I want to highlight green the furthest right entry from a row of cells, when a new entry is added, remove the green colour from the pre-latest cell and only colour the furthest right cell
So if i type a value in D5, D5 becomes green but D4 has no colour anymore
Bookmarks