You're right, I apologize for my vagueness. I see how it works on your example sheet but I cannot duplicate the efforts on my own. I can copy and paste your formula to do exactly what you did but when I try to apply it elsewhere by changing just the simple data I fail. Please see attached sheet.
I am trying to get column J to fill red when a date is not entered 30 days after column I if it has a 1 in column C, 15 days if it has a 2 in column C, and 7 days if it has a 3 in column C. Please see my conditional formatting to see where I am messing it up.
|