Chart Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone please advise me with Excel? I am usually pretty decent at almost everything, except sometimes some formulas I have forgotten

Anyway, we are setting up a worksheet in which after thirty days, we would like the information to change colors. Example...Delivery Receipt 16754, etc. dated November 2, 2003 is black. As of tomorrow, December 3, 2003, it will change color to red or blue or whatever because it is over thirty days

Please help us, we really appreciate it
 
If you have date created in a1, current date in b1 ie =TODAY(), then in C1
put =datedif(a1,b1,"d")

All you would have to do is select the entire worksheet and go into
conditional formatting, then change to 'Formula is' and enter
=if($c$1>30,true,false) and set the format to be pattern red.

HTH


Jen @ Fazio said:
Could someone please advise me with Excel? I am usually pretty decent at
Click to expand...
almost everything, except sometimes some formulas I have forgotten.
Anyway, we are setting up a worksheet in which after thirty days, we would
Click to expand...
like the information to change colors. Example...Delivery Receipt 16754,
etc. dated November 2, 2003 is black. As of tomorrow, December 3, 2003, it
will change color to red or blue or whatever because it is over thirty days.
 
Back
Top