Conditional Formatting - Based on Cell Value in another column

Question

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 highlightA4: 7/12/2019 B4: Should highlight red because this is within 30 days&nbsp;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 · Answer

Highlight column B and try this custom conditional formatting formula:=A1-TODAY()&lt;=30

adavis726 · Answer

Twifoo&nbsp;That seems to have turned the whole B column red.

sergeibaklan · Answer

adavis726&nbsp;
=($A1-TODAY()&lt;=30)*($A1&gt;1)
to exclude blank cells in column A

Forum Discussion

Conditional Formatting - Based on Cell Value in another column

3 Replies