I have tried so many things, and can't get anything to work. I have 3 columns that I want to return the MIN date - 30 days from into another column. And, then I want to set conditional formatting to highlight the row if that date is today or before. I have all of that figured out. But, if I don't have anything in the 3 columns that it is pulling from it returns ####### in the results column. And the conditional formatting is highlighting all of those columns as red. How do I have it ignore the formula if any of the criteria columns are blank?
Test Tracking Log.xls | |||
---|---|---|---|
B | |||
8 | |||
PHYSICIAN CREDENTIAL TRACKING |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A3:R1500 | Expression | =AND($Q3<>" ",$Q3<TODAY()) | text | YES |