conditional formatting
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.
|