May 05 2021 02:37 AM
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/2021 | 15/04/2021 |
Hope this makes sense and someone can help,
Thanks
S
May 05 2021 04:29 AM
May 06 2021 02:32 AM
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
May 06 2021 02:38 AM
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.