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.
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.
@Twifoo That seems to have turned the whole B column red.
to exclude blank cells in column A