Excel Formula

Occasional Visitor

Basically I want to sort some data into groups. I have a column of date of birth. For example 23/04/2014, 21/08/2017, 11/10/2011. In another column, if the date of birth is between 01/09/2010-31/08/2013, I want the cell to automatically go green with 1 in middle. If the date of birth is between 01/09/2013-31/08/2015 I want it to go red with 2 in the middle. If the date is between 01/09/2015-31/08/2018 I want the cell to go blue with 3. Is this possible?

1 Reply

@LukeFoster98 The easiest would be to use a look table where you set the lower boundaries for each date group and their corresponding values (1, 2 or 3) and then use conditional formatting to assign a colour to each of the values. Attached a workbook with a working example.