Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate the diference of times in excel? | Excel Worksheet Functions | |||
Change cell Colour when a number of days have been passed | Excel Discussion (Misc queries) | |||
How to change cell colour, X no days from inserted date in Excel? | Excel Worksheet Functions | |||
Accentuate diference between two values | Charts and Charting in Excel | |||
Having a due date flag in a different colour 30 days from current. | Excel Worksheet Functions |