how to seen diference colour after before 30 days
 

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

how to seen diference colour after before 30 days
 

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

" wrote:

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

how to seen diference colour after before 30 days
 

Dear Sridhar,

Thanks for your good help

Best Regards
Anshad

On Nov 6, 1:25 pm, yshridhar
wrote:
Try this
Format|Conditional formating
formula is = a1-now()<30
change the colour pattern
Use appropriate cell for your worksheet.
Regards
Sridhar



" wrote:
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- Hide quoted text -

- Show quoted text -

how to seen diference colour after before 30 days
 

You are most welcome Anshad
with regards
Sridhar

" wrote:

Dear Sridhar,

Thanks for your good help

Best Regards
Anshad

On Nov 6, 1:25 pm, yshridhar
wrote:
Try this
Format|Conditional formating
formula is = a1-now()<30
change the colour pattern
Use appropriate cell for your worksheet.
Regards
Sridhar



" wrote:
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- Hide quoted text -

- Show quoted text -