I am trying to create a formula or conditional format which does the following for me.
Say A1 is a date entered for the completion of a job. I want to conditional format this cell so that it turns red after a period of time say 4 weeks. This part is ok but I also want to return to the pre formatted state if cell A2 has a date of payment received entered in it. Therefore it is like a conditional format with an IF statement thrown in. I'm sure there is a reasonably easy way of doing this but haven't been able to work it out yet. Could anyone (vog maybe!) help. Many thanks in advance.
Thanks for the lightning response VoG! I think this is very close to what I'm looking for but can't get it to work properly. I need A1 to change after 30 days so for the sake of the argument, say a job had been completed on 1st May I want it to change on 31st. A2 would remain empty until payment is received but once a date is entered in A2 to confirm a payment has been madeI want A1 to revert to it's original format. Sorry if I'm being a bit thick but I'm struggling to get my head round this one!