Forum Discussion
Conditional Formatting - multiple column values
Hello, I'm wanting to use conditional formatting to cross out names in a list in column I if dates in column A are within 7 days and same name appears in column B
=(A2>=TODAY())*(A2<=TODAY()+7)*(B2=I2)You can try this rule for conditional formatting. The dates have to be within 7 days of today.
=$I$2:$I$25This is the "applies to" range in the example.
- Hmm... that doesn't seem to be working, I'm not getting an error it's just not doing anything. I'm wondering if I'm going to have to enter every name in an IF function. I was hoping I didn't need to do that.
Does it work in the attached file?
- No, it appeared as though it was but when I entered Bert into 10/28 it didn't cross him out
- Thank you so much I'll give it a shot!
