Office 2016 conditional formatting not updating executives dating women uk
If you change the name, the rule removes the highlight. When you reassign the record, you want the highlight to disappear, as shown in Figure A.The record no longer belongs to Bill, the project leader. On the other hand, if John is the new project leader, you must update the underlying rule because you want the highlight to remain.Sometimes you want to highlight dates that match the current date.
Try not to get too hung up on the simple and (very) contrived example.
When changes occur frequently, you should re-evaluate the setup.
The project leader position is the condition, not the name of the person who happens to be the project leader at any given time.
John's record (instead of Bill's) is now highlighted.
Figure D A more complicated condition doesn't change this solution.