SOLVED

Conditional formatting - using information from two columns

Copper Contributor

Hello everyone,

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

  1. Highlight cells in Column D if the corresponding cell in Column C is 1 or greater. AND
  2. The 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!

Conditional formating.png

2 Replies
best response confirmed by Lisa_-_ExecAdmin (Copper Contributor)
Solution
=AND($C2>=1, $D2<=TODAY())

as example
This worked perfectly! Thank you so much!
1 best response

Accepted Solutions
best response confirmed by Lisa_-_ExecAdmin (Copper Contributor)
Solution
=AND($C2>=1, $D2<=TODAY())

as example

View solution in original post