Forum Discussion
Solved
Conditional Formatting of Full Row Based on Data in One Cell Troubleshooting
Hey all! I'm building a basic spreadsheet where I want the full row to be formatted based on a single cell. I can get the cell itself to format with the formula I'm using, but once I try to "Appl...
Why did you use $E1>TODAY()+30 instead of $E1<TODAY()+30 ?
Sorry about that, my mistake.
When I enter "=AND($E1>0, $E1<TODAY()+30)", this is what happens:
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.