Automatic updating Sheet1 to Sheet2 with Conditional Formatting

[stacie68]

I have a cell in worksheet 1 with a number value. When that number is entered, I would like a few cells in the row to change color in worksheet 2.

For example: Column A in sheet1 has the number 137 in a cell.
Column D in sheet2 will have 137 entered into a cell also.

When the number 137 is entered into Column D on sheet 2
I would like 137 in Column A on sheet1 to highlight cells A-F in the corresponding row with a color of my choice (not changing the color of the font, just the background). So Sheet 1 (Daily) is updated when data entered into sheet 2 (C-Cert)


The Tab name for Sheet 1 is Daily
The Tab name for Sheet 2 is C-Cert

Thank you