Expert: Richard Rost - 7/8/2009

Question
Good Day

Thank you for taking the time to answer my question


What I am trying to do is to know 90 days before a day is to come in to effect and to have it high light red.

spread sheet. I was given this formula
=AND(INT(NOW())>0,INT(NOW()-B1)<=90)

I was given this formula by another expert but it doesn't seem to be working.

also how would I go about setting up a formula to know how many days past due something is?

thank you in advanced

Andrew

Answer
Just make another field and set that field equal to:

=IF((A1-90)<=TODAY(),1,0)

Where A1 is your date. Format this cell as a number. Now, use conditional formatting to set this cell's color if it's 1 or 0 (true or false).

Excel has a feature called Conditional Formatting that you can use to change the format (color, font, bold, etc.) based on the value of the cell.

See this FREE video tutorial on my web site for instructions on how to use Conditional Formatting.

http://599cd.com/tips/excel/conditional-formatting/?key=AllExperts

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www.599cd.com/Excel/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Excel Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts