Conditional Formatting for appointment spreadsheet

Hello:

I would like to conditionally format my excel 2007 spreadsheet at work to highlight in color the patient appointment date cells that are approaching 90 days old (appointments every 90 days). I have not been able to find a formula that does this. The toolbar only has a drop-down option for "last month". I would appreciate any ideas or any manuals I can turn to to help me out.

Cordially,
bsspsyd

Are you saying, if there is an appointment for 1/11/2013, then starting today that appointment would highlight since it has reached within 90 days?

If this is the case and let's say in column N is the appt date of 1/11/2013

Conditional Formatting

• Highlight applicable range >> A1:N100
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =$N1-90>=TODAY()
• Format… [Number, Font, Border, Fill]
• OK >> OK

You should be able to use =TODAY()-90>=$N1

If you just want to check for the month and not a certain date,

=MONTH(TODAY())=MONTH($G1)+3

G1 >> 1-Jul-12 >> Month = 7

Today >> 13-Oct-12 >> Month = 10

So the million dollar question, do you want 90 days to a date or just the month?

You are welcome...and thanks for the feedback
__________________________________________

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I don't quite know if you will find one site to fit all situations, but definitely this forum can get you a good sound answer within minutes.

A couple of places I like...

http://www.excelforum.com/excel-gene...additions.html

http://www.xldynamic.com/source/xld.CF.html#due

http://www.contextures.com/xlCondFormat02.html