Conditional Format If the date is more than a year

0
votes

I'm trying to apply a conditional format to Column J if in Column K the date is more than a year from Today. I have applied the following J2<=Today()-365 , however this is highlighting the entire column and is only validating for cell j2 how to validate for the entire column?

enter image description here

1
excelexcel-formulaconditional-formatting
Your conditional format rule should be =$K2<=TODAY()-365 to lock the column you want to check the date against. – asongtoruin
@asongtoruin So I have changed my formula, now it won't highlight any cell, any suggestions? – Luis

1 Answers

0
votes

You have J2as the conditions - you want to make that =K2<=Today()-365.

But, since you have multiple columns, etc. and conditional formatting can get wonky quickly, I suggest anchoring the cell reference, =$K2<=Today()-365 and make sure that rule applies to range $J$2:$J$[lastRow].