Conditional formatting

[Yankeedave]

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.

 

[SanjayGMusafir]

We recently had similar query on the forum. You may look into the thread and see if it delivers a solution for your problem.

conditional format to change color

I have a calendar that takes info from another sheet. On the info sheet, column "B" changes to green if column "I" has a date. I would like to replicate that on the calendar if possible and I'm so stuck. The calendar is LIVE and changes every month. If you can help me create the conditional...

www.mrexcel.com

 

[Yankeedave]

Many thanks for your reply. However whats CF should I use to check the status on another worksheet?

 

[SanjayGMusafir]

Many thanks for your reply. However whats CF should I use to check the status on another worksheet?

Did you go through this thread...

conditional format to change color

I have a calendar that takes info from another sheet. On the info sheet, column "B" changes to green if column "I" has a date. I would like to replicate that on the calendar if possible and I'm so stuck. The calendar is LIVE and changes every month. If you can help me create the conditional...

www.mrexcel.com