Linking Date range to cell Formatting
I am trying to link a timeline I am creating in one sheet to date values in
another sheet. One column in the timeline represents a range of days (e.g. Feb 1-15) and I want to insert a formula to recognize dates in corresponding cells in the other sheet. |
Linking Date range to cell Formatting
We need more info.
What does the data look like in both sheets? are you trying to match multiple items, for example a Feb 1 and Feb 2 cells or can there only be one item in the Feb1-15 period? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jason" wrote: I am trying to link a timeline I am creating in one sheet to date values in another sheet. One column in the timeline represents a range of days (e.g. Feb 1-15) and I want to insert a formula to recognize dates in corresponding cells in the other sheet. |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com