How do I format a column so that if the data changes it turns into a different color?

My workbook connects to a Google sheets, workbook via power query. I import the contents of the Google sheet and there’s one column that I work on. I’ve already conditionally formatted the power query output so that if the cell is blank, it turns that nice angry pink color we all know. Now, when I update the information in those blank cells I would like for it to change from the angry pink of a blank cell to any other color denoting a newly edited cell. Then after I’m done editing for the day, I opened up the Google sheet put in my changes and we begin a new the next day.

I cannot seem to conditionally format the cells so that if they change, they change color. If anyone has suggestions, I would be grateful. I’d prefer conditional formatting so that if needs changed down the road that’s a quicker edit. But VBA is not off the table. I’m comfortable with macros.

Thank you for looking.