Excel Font color change

Hello,

Our office uses excel to track internal audits. I would like the contents in the rows of columns A thru G to turn red when I enter the date in the row under column H. This confirms that i have closed the audit. Any help would be much appreciated...

Thanks,

Chris