Yankeedave
New Member
- Joined
- Apr 10, 2024
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Good morning all. I am having issue trying to get conditional formatting to work.
I am using a cover sheet for my excel document within excel. On the cover sheet is a "Compliance monitor" Pic1.
What I want to happen is the cell next to each title to change colour when a expiry date has been met. Each title is associated with a worksheet.
The work sheets either will have one column or multiple columns of dates. These dates change colour when expired or within 30 days to expire.
I want the compliance monitor to look at the dates within the work sheet and change colour when any of the dates expire. This way a user can just quickly check the cover sheet to see if any of the compliance categories had expired.
Pic 2 is a single Coolum of dates and pic 3 is multiple column of dates.
Many thanks for your help.
I am using a cover sheet for my excel document within excel. On the cover sheet is a "Compliance monitor" Pic1.
What I want to happen is the cell next to each title to change colour when a expiry date has been met. Each title is associated with a worksheet.
The work sheets either will have one column or multiple columns of dates. These dates change colour when expired or within 30 days to expire.
I want the compliance monitor to look at the dates within the work sheet and change colour when any of the dates expire. This way a user can just quickly check the cover sheet to see if any of the compliance categories had expired.
Pic 2 is a single Coolum of dates and pic 3 is multiple column of dates.
Many thanks for your help.