SOLVED

Status field in Excel from multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2156107%22%20slang%3D%22en-US%22%3EStatus%20field%20in%20Excel%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156107%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20dilemma.%20I%20have%20a%20spreadsheet%20with%203%20different%20columns%20with%20following%20information%3A%20start%20date%2C%20apply%20from%2C%20end%20date.%20In%20a%204th%20column%20I%20want%20a%20color%20depending%20on%20the%20information%20of%20the%20other%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20date%20in%20any%20of%20the%20columns%20are%20today%20-10%20days%20the%20color%20should%20be%20green%2C%20If%20today%20-5%20day%20the%20color%20should%20be%20yellow%2C%20If%20today%20it%20should%20be%20orange.%20If%20the%20date%20is%20today%20or%20today%20%2B5%20days%20should%20be%20red.%20Anything%20outside%20of%20this%20should%20give%20no%20color.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20figure%20out%20what%20kind%20of%20formula%20I%20can%20use%20to%20get%20this%20resoult%20if%20at%20all%20possible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20hint%20is%20much%20appreciated%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2156107%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-2156181%22%20slang%3D%22en-US%22%3ERe%3A%20Status%20field%20in%20Excel%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156181%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F974871%22%20target%3D%22_blank%22%3E%40TanjaO%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 

 

I have a dilemma. I have a spreadsheet with 3 different columns with following information: start date, apply from, end date. In a 4th column I want a color depending on the information of the other columns. 

If the date in any of the columns are today -10 days the color should be green, If today -5 day the color should be yellow, If today it should be orange. If the date is today or today +5 days should be red. Anything outside of this should give no color. 

 

I can't figure out what kind of formula I can use to get this resoult if at all possible. 

 

Any help or hint is much appreciated 

3 Replies
best response confirmed by TanjaO (New Contributor)
Solution

@TanjaO 

See the attached workbook.

@Hans Vogelaar 

That looks exactly what I am after. But how do you get the colouring? I can't see any formulas in the cell

@Hans Vogelaar 

Ops! I found it. Thank you so much for the quick reply.