Forum Discussion
Excel Formula
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/2...
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.