Complicated Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1521960%22%20slang%3D%22en-US%22%3EComplicated%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521960%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%20I%20am%20trying%20to%20create%20an%20excel%20%22Live%22%20document%20where%20there%20are%204%20date%20columns%20that%20I%20would%20want%20to%20draw%20conditional%20formatting%20from.%26nbsp%3B%20there%20is%20a%20picture%20attached%20but%20ill%20explain%20it%20here%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20%26nbsp%3BI%20want%20the%20row%20to%20be%20NO%20FILL%20if%20there%20is%20nothing%20in%20the%20%22Date%20Assigned%22%20cell%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20%26nbsp%3BThe%20row%20to%20be%20yellow%20if%20there%20is%20a%20date%20in%20the%20%22Estimated%20Completion%20Date%22%20cell%20but%20%22Today's%20Date%22%20does%20not%20surpass%20that%20date%3C%2FP%3E%3CP%3E3.%26nbsp%3B%20%26nbsp%3BThe%20row%20to%20be%20red%20if%20%22Estimated%20Completion%20Date%22%20has%20been%20passed%20by%20%22Today's%20Date%22%20but%20not%20if%20there%20is%20a%20date%20in%20the%20%22Date%20Completed%22%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E4.%26nbsp%3B%20%26nbsp%3BThe%20row%20to%20be%20green%20if%20there%20is%20any%20date%20in%20its%20%22Date%20Completed%22%20cell%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B-%20The%20%22Today's%20Date%22%20column%20uses%20the%20function%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DTODAY()%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B-%20The%20Estimated%20Completion%20Date%20will%20always%20be%201%20month%20(30%20days)%20ahead%20of%20the%20%22Date%20Assigned%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx.%20%3DC3%2B30%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20this%20even%20possible%20in%20excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1521960%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1522053%22%20slang%3D%22en-US%22%3ERe%3A%20Complicated%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1522053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728515%22%20target%3D%22_blank%22%3E%40Brandon_Y_1991%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1523598%22%20slang%3D%22en-US%22%3ERe%3A%20Complicated%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523598%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20did%20it!!!%20Thanks%20for%20the%20help.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi.  I am trying to create an excel "Live" document where there are 4 date columns that I would want to draw conditional formatting from.  there is a picture attached but ill explain it here as well. 

 

1.   I want the row to be NO FILL if there is nothing in the "Date Assigned" cell

2.   The row to be yellow if there is a date in the "Estimated Completion Date" cell but "Today's Date" does not surpass that date

3.   The row to be red if "Estimated Completion Date" has been passed by "Today's Date" but not if there is a date in the "Date Completed" cell. 

4.   The row to be green if there is any date in its "Date Completed" cell

 

 - The "Today's Date" column uses the function

 

=TODAY()

 

 - The Estimated Completion Date will always be 1 month (30 days) ahead of the "Date Assigned"

 

Ex. =C3+30

 

is this even possible in excel?

2 Replies

@Brandon_Y_1991 

Try this.

 

You did it!!! Thanks for the help.  @Peter Bartholomew