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.
Thank you so much I'll give it a shot!