Forum Discussion

Jenbons's avatar
Jenbons
Copper Contributor
Jun 20, 2022

Conditional formatting to highlight a cell where 2 dates match

I'm trying to create a spreadsheet with a Gantt chart layout, and want to use conditional formatting to place a colour cell where a particular activity starts.  I have the dates running across the top of the Gantt on one sheet, and the project data with dates of activities in another sheet.  I'm therefore looking for a formula whereby if a date in the project data sheet matches a date running across the top of the Gantt, that cell will be coloured.  

How do I do that? 

Here's the Gantt sheet: 

And this is the source project data sheet: 

 

 

4 Replies

    • Jenbons's avatar
      Jenbons
      Copper Contributor

      OliverScheurich Thank you - but I can't get that to work. I've simplified things by pulling the dates into the same sheet as below - is there a simpler formula which asks if 2 dates match between row 3 and column D, shade that cell in relation to the date of row 3?