Formatting date in excel to highlight when 2 weeks have passed original date

New Contributor

Hi All,

Is there a way of highlighting a cell that is 2 weeks passed a previous date?

For example date below 26/03/2021 (A1) and 15/04/2021 (B1), I Would like cell B1 to highlight in color when it is 14 days since A1?

26/03/202115/04/2021

Hope this makes sense and someone can help,

Thanks

S

3 Replies

@sazm098 

You could apply conditional formatting rule as

image.png

@Sergei Baklan 

Thanks a mill it seems to work for a single cell but when I try to format a whole column it highlights all the cells even though it is not correct all the way down. For example cells I have highlighted manually in yellow - the cells in column B are still highlighting in red when they are within 14 days,

Thanks

 

sazm098_2-1620293485286.png

 

@sazm098 

If you Apply To entire range (B1:B13) in formula still use only first cell of the range, i.e. =$B1>$A1+14

Excel automatically iterates formula for the entire range.