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

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

Bill,

Use conditional formatting. So say requested date is A1, confirmed is A2. In
A2, add the CF. condition of Formula Is and a formula of =A2A1 and then set
the pattern colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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