ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking Date range to cell Formatting (https://www.excelbanter.com/excel-worksheet-functions/220148-linking-date-range-cell-formatting.html)

Jason

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.

Shane Devenshire[_2_]

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