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.
![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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.