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