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
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
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?
- 10/28 is October 28th, I need to keep a log of calls that I review. My supervisor don't want me to review anyone that I have already reviewed in the last 7 days - essentially I have a master list of every rep that is recorded, I want the conditional formatting to automatically cross them off of the list if they have been reviewed in the last 7 days.