Oct 28 2022 08:52 AM
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
Oct 28 2022 09:26 AM
=(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$25
This is the "applies to" range in the example.
Oct 28 2022 09:45 AM
Oct 28 2022 09:53 AM
Oct 28 2022 10:19 AM
Does it work in the attached file?
Oct 28 2022 11:51 AM
Oct 28 2022 12:03 PM
What does 10/28 mean and can you describe as precisely as possible what you want to do? Ideally can you give some examples of your expected result?
Oct 28 2022 12:10 PM
Oct 28 2022 12:48 PM