Anyway to display who made an edit in a cell adjacent to the edit and also make certain cells automatically change color?

Hello! I am looking to revamp some documents that my department at work uses (most are on OneDrive since they are getting rid of the majority of our physical storage drives by Q4 of this year.)

For several of our spreadsheets, there is a checkbox to see if a task was completed. Is there anyway for an adjacent cell to display which user checked off the task? I know how to make the adjacent cell say true or false, but I was hoping there was a way for it to print the user ID, as people are often forgetting to initial which tasks they have done (A few have complained that there are several people in the department doing nothing all day and I want to prove them wrong).

A similar question. I have one specific spreadsheet that uses multiple colors to display what needs done with the data. The cells in columns C through G are the ones that get colored. Again, we use check boxes to show which steps of the process have been competed. Is there anyway to have the cells in individual rows change color depending on which boxes have been checked? Right now we change colors manually.

• No color means that nothing needs done and none of the boxes are checked
• Orange means it needs completed now and none of the boxes are checked
• Blue means it should only be completed by request and none of the boxes are checked
• Magenta means that steps 1 and 2 are complete, but step 3 still needs completed. The first 2 boxes are checked
• Green means it is competed. All 3 boxes are checked.

I cannot provide my current spreadsheet because I would 100% lose my job if I did. Removing sensitive date would more or less remove everything form the spreadsheet. (names, addresses, what product they are using, etc.)