Conditional formatting across multiple columns

Question

Hi&nbsp;&nbsp;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:&nbsp;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.&nbsp; Just to show duplicate dates that are in the same row.&nbsp;I would be very grateful if someone has got an answer!&nbsp;Thanks in advance.Maggie&nbsp;

dscheikey · Answer

KamikawaKazuma&nbsp;OFFSET() is not absolutely necessary.=COUNTIF($A2:$D2,A2)&gt;1Works too!

kamikawakazuma · Answer

Margaret_D&nbsp;Hi Maggie,&nbsp;The following formula works as attached."=COUNTIFS(OFFSET($A2,,,,4),A2)&gt;1"(Replace "$A2" as needed.)&nbsp;

Forum Discussion

Conditional formatting across multiple columns

2 Replies

Resources