SOLVED

Change the color of a cell based on a range of dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3184963%22%20slang%3D%22en-US%22%3EChange%20the%20color%20of%20a%20cell%20based%20on%20a%20range%20of%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3184963%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20in%20which%20Column%20E%20is%20calculating%20a%20date%20based%20upon%20a%20date%20entered%20in%20Column%20A%20and%20adding%20a%20set%20number%20of%20days%20to%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20to%20have%20column%20E%20shaded%20to%20a%20given%20color%20if%20the%20calculated%20date%20is%20between%20today%20and%2030%20days%20from%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3184963%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3185009%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20color%20of%20a%20cell%20based%20on%20a%20range%20of%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3185009%22%20slang%3D%22en-US%22%3ESelect%20column%20E%20and%20then%20go%20to%20Home-%26gt%3BConditional%20Formatting%20and%20Add%20New%20and%20then%20select%20Based%20on%20Formula.%3CBR%20%2F%3EThen%20in%20the%20formula%20box%20use%3A%3CBR%20%2F%3E%3D(E1%26gt%3BToday())*(E1%26lt%3B(Today()%2B30))%3CBR%20%2F%3EMake%20sure%20to%20click%20Formatting%20and%20select%20the%20background%20color%20you%20want.%3C%2FLINGO-BODY%3E
New Contributor

I have a spreadsheet in which Column E is calculating a date based upon a date entered in Column A and adding a set number of days to it.

 

I wish to have column E shaded to a given color if the calculated date is between today and 30 days from now

3 Replies
best response confirmed by mtarler (Trusted Contributor)
Solution
Select column E and then go to Home->Conditional Formatting and Add New and then select Based on Formula.
Then in the formula box use:
=(E1>Today())*(E1<(Today()+30))
Make sure to click Formatting and select the background color you want.
Thank you it was the * that I was missing, but you also have one extra ")" at the end of your formula.

I appreciate the assistance!
You're very welcome. Alternatively you could use AND().
As for having an extra ")" in the formula I don't see it, but since you got it to work i will close this out for you