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...
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.