Forum Discussion
Last Cell In A Column With Conditional Formatting
I am using the formula =K2<TODAY()-28 in a row to highlight any dates in a column red that are older than 28 days. The last cell in the column is highlighting red regardless of the date (ie I put in today's date and it highlights red). Is there a way to fix this? I am using Office 365.
Thank you!
Hi Lizz,
Hard to say what's wrong based on picture. Check if only one rule is applied to the range; check what's the range (if on K2 in Ribbon click Find & Select->Go To Special-> check Conditional formatting; it shoiws you visually then)
I did what you said, but it's not showing me anything. It worked previously on another sheet, but it isn't now.
SergeiBaklan wrote:Hi Lizz,
Hard to say what's wrong based on picture. Check if only one rule is applied to the range; check what's the range (if on K2 in Ribbon click Find & Select->Go To Special-> check Conditional formatting; it shoiws you visually then)
Lizz, if your rule formula based on K2 and applied range starts from $K$1 that could be the situation like yours
- criteria is checked based on the value in next row, not on current value.
That could be something else as well - hard to say without the file.
