I'm curious to know if there is a way to apply conditional formatting to cells within a row for cells that are equal.

For example I have dates in several columns. For rows that contain dates that are equal to other date columns I wish to highlight these cells to make them pop out.

Example of data: enter image description here

Example of individual cells conditional formatting: enter image description here

  • 1
    Try to use Conditional Formatting.
    – Lee
    Apr 19, 2019 at 8:11
  • @Lee Well certainly. Which is why I originally tagged the question with the tag conditional-formatting. How to utilize this feature or any other feature to reach my intended goal is the question. Apr 19, 2019 at 22:31

1 Answer 1


enter image description here

How it works:

  • Sample Data rang is A1:G9.
  • Hold Ctrl button Select Cells, you want to Highlight for duplicate Dates, by Mouse Click.
  • From HOME TAB select Condition Formatting, Highlight Cells Rule then Duplicate Values.

enter image description here

  • From next dialogue box, assure DUPLICATE option has been selected.
  • From list on Right select color combination or you may hit Custom Format.

enter image description here

  • Apply an appropriate color and finish with Ok.
  • It 'almost' works. Not sure if I am just missing a step but it is also highlighting duplicates within the Column. If there are dups within a column I don't care... I only am looking to highlight dups in rows. What am I missing? in the example screenshot you provided there are no duplicates dates in your columns and so it's hard to tell if you solution would work based on the sample data you used. Again, I only say this as I am unable to get the duplicate feature NOT to find dups in the column. Apr 19, 2019 at 22:27
  • @CodeNovice, nothing wrong with the procedure,, just for neatness I've not included many Duplicate Dates,, otherwise it works for Column also. For example enter 01/01/19 in Column C in any Cell, will be highlighted,, since Column has 01/01/19 already in first Cell. Since you found solution is working then you may accept it as answer as well as up vote also. ☺ Apr 20, 2019 at 6:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.