There doesn't seem to be an awful lot of logic in the process.
Still, it's doable with a worksheet change event. Unfortunately, I'm not near a computer at the moment.
In brief, when any cell changes, you need to clear the interior colour of ALL the cells. Then you change the colour of the Target cell.
It's two lines of code but I can't think of the syntax.
Something like:
Private Sub Worksheet_Change(Target as Range)
Cells.Interior.Color= ... something
Target.Interior.Color= ... something else, like 3
End Sub
You can record a macro to check the syntax and colour indexes.
Regards, TMS
Bookmarks