Hi, my problem is related to Lolla70's previous post that was moved to the programming section. In the profiling of households, the members (Column A) are categorized into groups (Column D) according to their age (Column C). I need help in:




1. A conditional formatting formula that will highlight the name of a member whose group status (Column D) was changed in the last quarter or 90 days. The profile date is entered in $B11.

2. Is there a formula that will calculate the age group (Column D) without Column C?


Thank you.

Attached Files

Class by Age.xlsx (83.6 KB, 9 views)