|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to highlight the cells using conditional formatting? | LearnerExcel | Excel | 1 | 01-01-2019 01:43 AM |
How to fill a cell at row and column intersection with conditional Formatting | Iraj | Excel | 10 | 12-02-2017 09:54 AM |
How to highlight cells using Vlookup / conditional formatting | mikehk | Excel | 2 | 09-18-2017 07:30 PM |
Conditional Formatting a column | Washbue1 | Excel | 3 | 01-27-2017 01:11 PM |
Conditional Formatting for Cells Containing Formula | Gillian623 | Excel | 1 | 12-09-2016 11:03 PM |