Colorize IF Within 5 Days Prior to Cell's Value

[ChrisOK]

Preferably looking for a formula to drop into Conditional Formatting - but okay if you have a better VBA option...

QUESTION:
What would be the best way to colorize a cell or range of cells if it's within 5 increments prior of the cell's content.

ie: cell A1 has a "15" in it (meaning due date is the 15th of the month )
I'd like that cell to turn "RED" if we are within 5 days of the 15 of the month...
Once the 15th is past - no colorization needed.

( it would need to look at the computer's calendar and know TRUE or FALSE and colorize if True )

Any quick ideas?

 

[Brian from Maui]

Preferably looking for a formula to drop into Conditional Formatting - but okay if you have a better VBA option...

QUESTION:
What would be the best way to colorize a cell or range of cells if it's within 5 increments prior of the cell's content.

ie: cell A1 has a "15" in it (meaning due date is the 15th of the month )
I'd like that cell to turn "RED" if we are within 5 days of the 15 of the month...
Once the 15th is past - no colorization needed.

( it would need to look at the computer's calendar and know TRUE or FALSE and colorize if True )

Any quick ideas?

Well you wanted a quick one Chris,

=DAY(TODAY())=A1

Where A1 houses a number. Adjust the less than or greater than....

 

[ChrisOK]

Thanks for your expeditious help!

Got it!

=DAY(TODAY())-5

 

[Brian from Maui]

Thanks for your expeditious help!

Okay, I opened up A1, conditional format, chose formula, pasted the formula in there --- and plugged in a "-5" on the end, within the parens, etc -- trying to figure out where to define that variable and get it to work within the supplied function?

Can you elaborate?

Chris,

Maybe something like this....

=(Day(Today())-A1) > 15

I got some real world work to finish, I'll check back later

 

[ChrisOK]

I thought I had it working --- but thought wrong --

It should change color if today is within 5 of the cell contents:
Since today is Feb 9th, only the ones with an X by them would turn color:

1
3
5 X
7 X
9 X
12
25
30

9,8,7,6,5 would be the contents it would look for before turning color

If today was the 25th of the month, only the cell that shows "25" in the above list would light up....because 12 is more than 5 away and 30 is BEYOND today's date -- so it's not applicable....

?