Forum Discussion
Conditional Formatting of Full Row Based on Data in One Cell Troubleshooting
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.
It's possible that I don't understand the formula, but these screenshots are from 1-Nov-23 meaning (TODAY()+30) should equal 1-Dec-23. If this is true, the only row that should be highlighted is Row 4 because E4 contains the date 18-Nov-23 which is >0 and <1-Dec-23 (TODAY()+30). However, Row 5 is also highlighted even though E5 contains 14-Jan-23 which is not <1-Dec-23 (TODAY()+30).
But 14 January 2023 is definitely before 1 December 2023. It's not 14 January 2024 !!!