Hi 

Is there a way that you can do conditional formatting across 4 columns but 1 row?

I have got a spreadsheet that has got 4 different projects on, with date columns, and I want to highlight if any of the projects in the same row have got the same date:

I have tried doing the COUNTIF, CONCAT formulas etc, and they are not what I need. I need exactly what is on the screen here.  Just to show duplicate dates that are in the same row.

I would be very grateful if someone has got an answer!

Thanks in advance.

Maggie

​Hi  Is there a way that you can do conditional formatting across 4 columns but 1 row?I have got a spreadsheet that has got 4 different projects on, with date columns, and I want to highlight if any of the projects in the same row have got the same date: I have tried doing the COUNTIF, CONCAT formulas etc, and they are not what I need. I need exactly what is on the screen here.  Just to show duplicate dates that are in the same row. I would be very grateful if someone has got an answer! Thanks in advance.Maggie   Read More

​