Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2370582%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2370582%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EJust%20wondering%20if%20someone%20can%20help%20me%2C%20I%20need%20to%20enter%20some%20conditional%20formatting%20into%20my%20spreadsheet%20and%20can't%20work%20out%20the%20formula.%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20is%20the%20row%20to%20turn%20red%20when%20the%20recall%20date%20in%20column%20E%20is%20reached.%20Then%20when%20a%20date%20is%20entered%20into%20column%20F%20I%20would%20like%20the%20row%20to%20turn%20yellow.%20And%20lastly%20when%20a%20date%20is%20entered%20into%20column%20I%2C%20I%20would%20like%20the%20row%20to%20turn%20green.%3C%2FP%3E%3CP%3ECould%20someone%20steer%20me%20in%20the%20right%20direction%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2370582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2370688%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2370688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1058447%22%20target%3D%22_blank%22%3E%40jbutlerorth%3C%2FA%3E%26nbsp%3BSee%20attached%20file.%20I%20believe%20it%20has%20the%20CF%20rules%20you%20need.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2370728%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2370728%22%20slang%3D%22en-US%22%3E%3CP%3EAmazing!%20Thank%20you%20so%20much!%20My%20only%20problem%20is%20that%20on%20my%20actual%20spreadsheet%20the%20rows%20further%20down%20the%20list%20that%20haven't%20has%20anything%20entered%20yet%20are%20coming%20up%20red%2C%20any%20suggestions%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

Just wondering if someone can help me, I need to enter some conditional formatting into my spreadsheet and can't work out the formula.

What I would like is the row to turn red when the recall date in column E is reached. Then when a date is entered into column F I would like the row to turn yellow. And lastly when a date is entered into column I, I would like the row to turn green.

Could someone steer me in the right direction?

Thanks!

2 Replies

@jbutlerorth See attached file. I believe it has the CF rules you need.

Amazing! Thank you so much! My only problem is that on my actual spreadsheet the rows further down the list that haven't has anything entered yet are coming up red, any suggestions?