Sheet1 references values on Sheet2. When a value is entered on Sheet2, I want the reference to that cell on Sheet1 to change the font color to red for 30 seconds based on the time it was entered.
ummmm....why? You might be able to, but honestly I've never seen this question asked from Excel users in 20 years.