Forum Discussion
MaxH
Nov 01, 2023Copper Contributor
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...
- Nov 01, 2023
MaxH
Nov 02, 2023Copper Contributor
Sorry about that, my mistake.
When I enter "=AND($E1>0, $E1<TODAY()+30)", this is what happens:
HansVogelaar
Nov 02, 2023MVP
That is what you asked for. If you want something else, please explain.
- MaxHNov 13, 2023Copper Contributor
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)"
- HansVogelaarNov 13, 2023MVP
E5 contains 14-Jan-23. That is >0 and <13-Dec-23 (TODAY()+30).
So I don't understand your remark.
- MaxHNov 14, 2023Copper Contributor
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).