Help with Highlight Formula

Hello Newbie here. I'm trying to create a formula to highlight all rows that contain certain values in certain columns.

Basically: Highlight if row contains "X" in Column B, AND, "Y" in Column C, AND, duplicate values in Column D.

As you can tell, my formula writing is not up to snuff. X and Y are text values and the duplicate values in Column D is a Date value (if that makes a difference).
Appreciate any help or advice on this thank you!

Use Conditional Formatting.

Column B
- "Format only cells that contain"
- Set [Cell Value] [equal to] "X"
- Set your desire formatting

Column C
- "Format only cells that contain"
- Set [Cell Value] [equal to] "Y"
- Set your desire formatting

Column D
- "Use a formula to determine which cells to format"
-

Please Login or Register  to view this content.

*assuming values are in D1 to D100
- Apply for format to the rest of the cells in D with Format Painter

Thanks lazyme for the reply! The only thing is that I'm hoping to highlight the whole row that contains all three things instead of individual cells which is what I think your solution does.

In that case, highlight the whole row, apply the Conditional Formatting with the "Use a formula to determine which cells to format" option.

Use the formula:

Please Login or Register  to view this content.

Play around with this to get what you desire.