conditional formatting

[Pete]

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

 

[T. Valko]

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?

 

[Pete]

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?

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

 

[Pete]

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.

 

[T. Valko]

Sorry, I don't understand.

--
Biff
Microsoft Excel MVP

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?

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