Hello everyone,

I’m looking for some assistance with setting up conditional formatting in Excel. Here’s what I need to accomplish:

Highlight cells in Column D if the corresponding cell in Column C is 1 or greater. ANDThe date in Column D is today’s date or earlier.

Note: The dates in Column D are being pulled from another worksheet.

The ultimate goal is to have the cells in Column D highlighted when the date is earlier than TODAY (which will always change) and the number in the adjacent Column C cell is 1 or greater.

Thanks in advance for your help!

​Hello everyone,I’m looking for some assistance with setting up conditional formatting in Excel. Here’s what I need to accomplish:Highlight cells in Column D if the corresponding cell in Column C is 1 or greater. ANDThe date in Column D is today’s date or earlier.Note: The dates in Column D are being pulled from another worksheet.The ultimate goal is to have the cells in Column D highlighted when the date is earlier than TODAY (which will always change) and the number in the adjacent Column C cell is 1 or greater.Thanks in advance for your help!  Read More

​