'Conditional Formatting for Calender

Good day, so I am trying to build a planning tool, where I am using a table with source data on one sheet, which I want to use to fill in cells with different colours in a calender sheet, depending on the job type for different dates. I can get conditional formatting to display single tasks, but have problems applying the conditional formatting throughout, i.e. if I have two entries for the same person in the table, I want both of them displayed in the calender. Anyone who can help? Table with source dataCalender, where i Want the different blocks be displayedConditional Formatting with Formulas, which I want to use to display periods from table in calnder

Please see below example what I want the calender to show and what I want it to be based upon. This what I want the calnder to showThese are the values I want the calender to be based upon

excelconditional-formatting


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Reading Excel file with Selenium WebDriver C# and web form with values

How to update an existing row or table of an existing xlsx file using pyexcel for python

Equivalent C# Function For Excels Norm.S.Inv Function

I keep assigning a value to my variable but it stays empty

Excel RTD (Real Time Data) client other than Excel?

Create table from data on a worksheet with specific name and add column

Is it possible to use 'Microsoft.ACE.OLEDB.12.0' provider without installation?

Using VBA to query a SQL Server table in Excel

How to stop scroll bar auto jump in vba

If IsEmpty then go to column A but in same row and extract that data

How can I use a for each loop on an array?

VBA - worksheet object is hidden

Outlook 2010 GAL with Excel VBA

how to read a value from Column Name in Excel in Java

Replace cell value with image