Conditional Formatting Across Sheets

Emmet McKenna

Hi, we have a Scheduling Sheet (with columns, wk 01, wk 02, wk 03, wk 04, etc). A Delivery Date column links into this sheet from another sheet.

What we do at present is highlight the relevant week column based on the date in delivery date, so for example from Jan 2nd to Jan 8th is wk 01 this year. (See screenshot attached)

Scheduling Sheet.jpg

The problem is the Delivery Dates can often change so the highlighted cell needs to then be manually changed. We are looking at a way of automating this and thought using conditional formatting might work, so that if the date falls within a certain range it highlights the relevant column (Screenshot attached).

Conditional Formatting.jpg

We need to do this across multiple sheets so are wondering if there is any method where a Template or Master Sheet can be setup and the Conditional Formatting can then be applied to certain sheets without having to update each individually? Would Control Centre allow us to do this?

Andrée Starå

Hi @Emmet McKenna

I hope you're well and safe!

Yes, It seems like it should work with a cell-linking or cross-sheet formula structure.

Please describe your process in even more detail and share the sheet(s)/copies of the sheet(s) or some screenshots. (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Emmet McKenna

Hi Andree,

The screenshots on the previous emails pretty much capture what we are trying to achieve. I've shared the links to test sheets with you via email. If you have any questions please let me know.

Thanks, Emmet

Andrée Starå

@Emmet McKenna

Excellent! I'll take a look and get back to you!

Emmet McKenna

Hi @Andrée Starå, did you get a chance to look at this?

Emmet McKenna

Hi @Andrée Starå, hope you are keeping well. Just checking if you had any solutions for the above issue?