I'm using Excel 2003 and have the following problem : If A1 = Date Billed B1 = Amount Billed C1 = Date Paid Using todays date and put in RED bold and F1 = Amount paid. When entering the amount paid F1 I want to clear A1 and B1 and make C1 show todays date and print in RED and Bold. Presently I must remove A1 and B1 by clearing the cells and then Change the Color to red and bold it. I'm sure there is a better way to do this step. Gene Shankweiler
Solved by M. B. in 22 mins