colored a cell
Hi Bill
what is the criteria for the colouring of the cells
i.e. is it something like this
requested delivery date < confirmed delivery date make the cell blue
requested delivery date confirmed delivery date make the cell green
or
confirmed delivery date requested delivery date + 2 weeks make the font
bold
this might help us come up with a solution for you.
Regards
JulieD
"Bill" wrote in message
...
I have plase a question in another forum and from the
answer i have receive i thing that i need programming
help.
So i have two cells with different dates.
One is the requested date of a delivery and the
other one is the Confirmed date of a delivery.
In a table i have all the dates. There is any possibility
to color a cell automatically?
For example. The confirmed date from a delivery is the
week 5. If there is a delay to make the cell have another
color or a format eg to be bolt. ?
There is any way to manage something like that?
and also because the file has to go to many different
offices. there is anyway that to make a macro or to have
a code that when i am sending the file to another person
to work without any problems?
With regards Bill
|