Excel - IF

Resolved · Urgent Priority · Version 2013

Thu 29 May 2014, 14:45 Delegate Christine said...

Christine has attended:
Excel Advanced course
Excel Advanced - For Power Users course
PowerPoint Introduction course

Excel - IF

Hello,

I'm trying to create a formula to achieve following outcome:

There are different tasks with different due dates. For tasks which are smaller than TODAY, I would like to have a GREEN Traffic light. For tasks which are 7 days smaller than TODAY, I would like to have a yellow traffic light. If TODAY is bigger than the due date, I would like to have the red traffic light.

The dates are in different columns and currently in this format: 31/05/2014

Thanks for your suggestion.

Christine

Fri 30 May 2014, 10:53 Trainer Jens said...

RE: Excel - IF

Hi Christine,

Thank you for the forum question.

You need to select the dates and click conditional formatting in the "Styles" group on the "Home" tab.

click new rule and have a look at the attached Excel file. On sheet 1 you will see my example. You will also find a picture with the conditional formatting settings.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu