Excel Font color change

[Closed]
Report
-
 Trowa -
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

1 reply

Try the conditional format option.