IF functions/conditional formatting

[PP299]

Hi All

I thought I had this sussed but as soon as my If function was entered into a particular cell my conditional formatting went ever so slighlty haywire.

This is my problem I have an if function in cell K8 (expected end date) which is =IF(c2=2, J8+140,J8+168) but I need to add some conditional formatting which states that cell K8 will turn red when it reaches 40 days before the current end date, amber when it hits 100 days and green any other time.

I have examples from a previous posting but they don't work with the IF function in place!

I hope you can help me.

 

[PP299]

other way around but yes! I need green if the date is not one of the others! so I need the date to turn amber when it hits 100 days and red with 40

 

[lenze]

Since you have mentioned different senarios, I'm not clear what you need and don't want to guess. You should be able to use the examples given to write formulas that will do what you want.

lenze