colored a cell

[Bill]

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

 

[JulieD]

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

 

[Bob Phillips]

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 =A2>A1 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)