G
Guest
Can anyone provide me with Step By Step instructions to do the following
please..
Dates are listed from A9:A39 (Month Of January) they show as 01 January 2007
What is the process i need to go throguh to get the FILL color of a box to
change Permanently to another colour, once the date has been reach and
recognised when the excel sheet is opened?
Eg: today is 07 January 2007 and the fill color is allready light blue on A15.
i open excel on the 08 January 2007.. what i want here is for the fill color
for 07 January to have changed to a Orange. (permanently) as it is a past
date.
This one probably cant be done... itll no doubt get you guys thinking.. If
you wanted a challenge.. here it is. ( or maybe not )
What i will need is..
Hi Dan, Do this... Click on ?? then on ??? then type ???? then select rage
??? etc etc right click on..........
Thnx guys
please..
Dates are listed from A9:A39 (Month Of January) they show as 01 January 2007
What is the process i need to go throguh to get the FILL color of a box to
change Permanently to another colour, once the date has been reach and
recognised when the excel sheet is opened?
Eg: today is 07 January 2007 and the fill color is allready light blue on A15.
i open excel on the 08 January 2007.. what i want here is for the fill color
for 07 January to have changed to a Orange. (permanently) as it is a past
date.
This one probably cant be done... itll no doubt get you guys thinking.. If
you wanted a challenge.. here it is. ( or maybe not )
What i will need is..
Hi Dan, Do this... Click on ?? then on ??? then type ???? then select rage
??? etc etc right click on..........
Thnx guys