I am trying to automate the colour of a cell depending on a date. In
cells A4:Z4 I have the weekending date starting at 08/01/2010 in A4,
then A4+7 in B4 then autofilling to Z4.

In cells C3:C100 I have the date I reviewed a Risk Assessment and
would like the cell that is closest to that date in A4:Z4 to
automatically colour "Red" to say that the next review is due that
week.

Can anyone help with this?

Thanks

Peter

It's not real clear what you want to do.

Do you want to highlight a cell in A4:Z4 or C3:C100?

A4:Z4 would contain 26 dates and C3:C100 would contain 98 dates. How can you
do a 1 to 1 comparison like that?

--
Biff
Microsoft Excel MVP


"Pete" wrote in message
...
I am trying to automate the colour of a cell depending on a date. In
cells A4:Z4 I have the weekending date starting at 08/01/2010 in A4,
then A4+7 in B4 then autofilling to Z4.

In cells C3:C100 I have the date I reviewed a Risk Assessment and
would like the cell that is closest to that date in A4:Z4 to
automatically colour "Red" to say that the next review is due that
week.

Can anyone help with this?

Thanks

Peter

On Jan 22, 2:14*am, "T. Valko" wrote:
It's not real clear what you want to do.

Do you want to highlight a cell in A4:Z4 or C3:C100?

A4:Z4 would contain 26 dates and C3:C100 would contain 98 dates. How can you
do a 1 to 1 comparison like that?

--
Biff
Microsoft Excel MVP

"Pete" wrote in message

...



Bill,

If C3=04/04/2010 and J1 contains 04/04/2010 then I would want Cell J3
to highlight. If there is not an exact match, I would want to
highlight the cell at the Intersection that matches the closes date to
that in Column C. e.g


01/01/10,08/01/10,15/01/10,22/01/10.............24/02/10,02/03/10,09/03/10,16/03/10
etc, etc
08/01/10 Highlight
22/02/10
Highlight
03/03/10
Highlight

Hope this makes more sense

Peter

On Jan 22, 5:55*pm, Pete wrote:
On Jan 22, 2:14*am, "T. Valko" wrote:



It's not real clear what you want to do.

Do you want to highlight a cell in A4:Z4 or C3:C100?

A4:Z4 would contain 26 dates and C3:C100 would contain 98 dates. How can you
do a 1 to 1 comparison like that?

--
Biff
Microsoft Excel MVP

"Pete" wrote in message

....

Bill,

If C3=04/04/2010 and J1 contains 04/04/2010 then I would want Cell J3
to highlight. If there is not an exact match, I would want to
highlight the cell at the Intersection that matches the closes date to
that in Column C. e.g

01/01/10,08/01/10,15/01/10,22/01/10.............24/02/10,02/03/10,09/03/10,*16/03/10
etc, etc
08/01/10 * * * * * * *Highlight
22/02/10
Highlight
03/03/10
Highlight

Hope this makes more sense

Peter- Hide quoted text -

- Show quoted text -

Sorry Bill, that hasn't formatted correctly I doubt you be able to see
what I mean from my reply.

Sorry, I don't understand.

--
Biff
Microsoft Excel MVP


"Pete" wrote in message
...
On Jan 22, 2:14 am, "T. Valko" wrote:
It's not real clear what you want to do.

Do you want to highlight a cell in A4:Z4 or C3:C100?

A4:Z4 would contain 26 dates and C3:C100 would contain 98 dates. How can
you
do a 1 to 1 comparison like that?

--
Biff
Microsoft Excel MVP

"Pete" wrote in message

...



Bill,

If C3=04/04/2010 and J1 contains 04/04/2010 then I would want Cell J3
to highlight. If there is not an exact match, I would want to
highlight the cell at the Intersection that matches the closes date to
that in Column C. e.g


01/01/10,08/01/10,15/01/10,22/01/10.............24/02/10,02/03/10,09/03/10,16/03/10
etc, etc
08/01/10 Highlight
22/02/10
Highlight
03/03/10
Highlight

Hope this makes more sense

Peter