Forum Discussion
Re: Conditional Formatting of Full Row Based on Data in One Cell Troubleshooting
Sorry about that, my mistake.
When I enter "=AND($E1>0, $E1<TODAY()+30)", this is what happens:
6 Replies
That is what you asked for. If you want something else, please explain.
In the above photo, the row starting with the word "Shucked" is highlighted even though it doesn't fit the criteria of "=AND($E1>0, $E1<TODAY()+30)"
E5 contains 14-Jan-23. That is >0 and <13-Dec-23 (TODAY()+30).
So I don't understand your remark.
