how to seen diference colour after before 30 days

A

anshad1

it is possible to see in excel sheet
for excample.

10/10/2007
15/11/2007
28/09/2007
30/04/2008
06/12/2007
18/08/2009

the above dates i want to see befor due for 30 days to change
difference colour or any other,
it is possible

please help me

Best Regards
Anshad
 
G

Guest

Try this
Format|Conditional formating
formula is = a1-now()<30
change the colour pattern
Use appropriate cell for your worksheet.
Regards
Sridhar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show the date when it is later than today's date 4
How do I have excel highlight days before & after a date on a cale 2
Time query 9
counting the number of consecutive days 12-17-09 2
Peak call times/hours 2
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
possible countif formula? 3
Find then highlight in yellow 6

Top