conditional formatting

  • Thread starter Thread starter Pete
  • Start date Start date
P

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
 
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?
 
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?
Click to expand...
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
 
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 -
Click to expand...

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


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?
Click to expand...
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
 
Back
Top