Jul 03 2019 05:50 AM
Hello everyone,
I am working on a spreadsheet that has a date in column A. I would like Column B to highlight red in the case that the date in the corresponding cell in column A is due in the next 30 days.
For example:
A3: 2/18/2017 B3: should not highlight
A4: 7/12/2019 B4: Should highlight red because this is within 30 days
Any thoughts on a formula for this? I've tried everything I can think of. I can get it to work for a single cell but not for the entire column.
Jul 03 2019 06:08 AM
Jul 03 2019 07:42 AM
@Twifoo That seems to have turned the whole B column red.
Jul 03 2019 01:46 PM