Conditional formatting, formula breakdown .

Hi Guys,


I been addicted to excel and this is killing me, I don't know how to do this, maybe someone can help me but what I really like to do, is i like to know how to do it!!!!.


I want a formula that can link to expiration date, where like if it's 35 days or lower to today's date, i want that row in red. but if that expiration date is 36 to 50 days close to today's date, i want it to stay light yellow. the rest can stay the same.



please help me, and if you can please explalin the formula, i'ts driving me crazy!!!.

i had something like this but IT AIN'T WORKING, =if(L2-D5=<35) then i wanted to apply a rule to that if it were true, the rule was for the entire to turn the proper color, depending on the date.