Conditional Formatting - Based on Cell Value in another column

Copper Contributor

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.

3 Replies
Highlight column B and try this custom conditional formatting formula:
=A1-TODAY()<=30

@Twifoo That seems to have turned the whole B column red.

@adavis726 

=($A1-TODAY()<=30)*($A1>1)

to exclude blank cells in column A