Conditional Formatting with IF statement

[bemp87]

Hi Community,

i'm needing some help with a Conditional Formatting using a IF statement. Here is what i have so far:

Column A: Name Of Customer (A1-Bob, A2-Sally etc.)
Column B: Date last contacted Customer: (A1: 09/01/2018, A2 10/01/2018)

I am trying to Conditionally format for the date entered in column B, if it is equal to or greater than 20 days from that date to fill the cell Yellow..


So far the formula i have is:

=IF(TODAY()-B2=>20....

I'm not sure if what I am trying to do is possible, but i feel I'm just missing something... Any help would be appreciated.

 

[Peter_SSs]

I'm not exactly sure of your requirement, but in general you do not need an IF function like that in a Conditional Formatting formula
Try just
=TODAY()-B2>=20

If the statement evaluates to TRUE then the conditional formatting will be applied.
If the condition evaluates to FALSE or an error then formatting is not applied.

I'm not sure whether you need < or > in your formula but whatever it is it should come before the = sign not after it like you have posted.

 

[bemp87]

Thanks Peter- this worked perfectly, to think I was one mistake off...

You're the best!

 

[Peter_SSs]

Thanks Peter- this worked perfectly

You're welcome.