conditional formatting
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 |
conditional formatting
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 |
conditional formatting
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 |
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. |
conditional formatting
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 |
All times are GMT +1. The time now is 11:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com