Excel - conditional formatting help

salway42 Sorry, but I don't follow your dates here. You mention that column F = C plus 90 days, but I guess you mean column G = C plus 90 days? You are using a date format d/mm/yyyy aren't you?

Similarly, you say that E = D plus 30 days. I guess, you mean F = E plus 30 days. And where do I find the "projected date"? And is it E and F you want to conditionally format, or perhaps F and G or G and H?

Any how, you should create two rules. One that checks if the cell value is between the "projected date" minus 5 days and the "projected date" (green). Another rule needs to check if the cell value is equal or greater than the "projected date" (red).