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
 
Y

yshridhar

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

count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
show the date when it is later than today's date 4
IF statement with 2 logicals 1
IF ARRAY with multiple conditions. 1
Count if between date parameters 4
How do I count the number of blank cells 0
How do I have excel highlight days before & after a date on a cale 2
Find then highlight in yellow 6

Top