Excel

Hi Carla,

I have created an example (please find attached Excel file).

If you look at the columns J to M, you can see the logic I use.

If you select all the dates in column B and click Manage Rules under Conditional formatting, you can select one rule at the time and click Edit rule and see each of my rules.

The order of the rules is very important in this example. In my example I want to highlight all invoices, which need to be paid within the next two weeks in yellow, but I also want to highlight all invoices, which need to be paid within the next two months in green. The rule within two weeks must be above within two months. The rule closest to the top in the manage rules dialog box has highest priority.

I have in my example under the logic columns numbered in which order the rules have to be created. You can in the Manage Rules dialog box move the rules up or down.

I hope this makes sense and by looking at what I have done, can make you able to do what you want.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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