Can I get some help modifying Excel Conditional Formatting
Can someone please help me modify this conditional formatting. Columns E and F have three possible conditions
one for =TODAY()
one for between =TODAY()+1 and =TODAY+4
one for between =TODAY()+5 and =TODAY+10
I want to tell it to only change if the row in columns E and/or F have a date in them AND if the cell on that row of column C is NOT blank. At the moment I get a red highlight when the dates in E and F are today but if I've done the assignment I don't need a red flag any longer. I'm sure I can pop the conditions into the last two but I'm mainly looking to modify the first one that creates a red flag effect.
by 
ANSWERS: 0
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC