Date specific conditional formatting

[gocolonel77]

I have a spreadsheet with my budget, bills and when each bill is due.

Cell M2 has the current date.

For example:

Cell R13 has a due date of 2-14-14.

I would like to have 2 conditional formats

1. When the bill is due in 3 days from current date the cell will highlight in yellow.
2. When the bill due date and the current date match, the cell will highlight in red.

Form sounds easy, but I am having difficulty with the function.

Thanks

Jason

[GC Excel]

Hi,
2 conditions with formulas :

1) =$R13<=$M$2 RED FILL
2) =$R13-$M$2<=3 Yellow fill

Both applied to a range =$R$13:$R$xxxx if you have multiple rows with due date.

If the first bill is on row 4, replace R13 by R4 in all cases...

[gocolonel77]

Thank you that work fine.

One more adaptation

Column S consists of Date Paid.

For instance R13 = when the bill is due. S13 will be blank until bill is paid to which I will type in the date the bill got paid. I want R13 to fill in as Green when I type the date I paid the bill in S13. Green will trump Red and Yellow conditions.

Can you help?
Thanks

[GC Excel]

Hi,

in R13, add the following condition with formula :

1) =$S13<>"" GREEN FILL

and the previous conditions :
2) =$R13<=$M$2 RED FILL
3) =$R13-$M$2<=3 Yellow fill

[gocolonel77]

Thank You you have been a great help