Forum Discussion
Conditional formatting - using information from two columns
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. AND
- 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!
- =AND($C2>=1, $D2<=TODAY())
as example
- =AND($C2>=1, $D2<=TODAY())
as example- This worked perfectly! Thank you so much!
