Office 2016 conditional formatting not updating
When changes occur frequently, you should re-evaluate the setup.
Figure A In a perfect world, you'd simply update the rule, =$A2="John", and go on.
John's record (instead of Bill's) is now highlighted.
Figure D A more complicated condition doesn't change this solution.
The simple data set in Figure A is a simplified version of what you might encounter.
A simple conditional rule, =$A2="Bill", updates records for the project's leader, Bill.
Search for office 2016 conditional formatting not updating:
Let's consider a simple data set that highlights records for a project's leader.