Search : in
By :

Excel Font color change

Last answer on Oct 8, 2009 12:54:55 pm BST Chris, on Oct 7, 2009 5:24:03 pm BST 
 Report this message to moderators

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

Configuration: Windows XP
Internet Explorer 6.0

1

 Trowa, on Oct 8, 2009 12:54:55 pm BST

Try the conditional format option.

Reply to Trowa