Hi,
I have a spreadsheet with two columns in which contain dates. i want the second column to be highlighted if the date is less than 6 weeks before the date in the first column. I have tried various variations of the conditional formatting including
=$B$2<$A$2+294
but this doesn't seem to work.
Please see example included - highlight cells in column B if the date is LESS than 6 weeks before the date in column A.
Any thoughts
Thanks
J
Bookmarks