Thread: [Solved] Conditional Formatting that highlights cells when there was a change in another column
View Single Post
 
Old 04-25-2019, 06:27 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Conditional Formatting that highlights cells when there was a change in another column
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
File Type: xlsx Class by Age.xlsx (83.6 KB, 9 views)
Reply With Quote