Excel conditional formatting not updating rob dyrdek and chanel dating
The example data set isn't important — the option that I'm offering is.When altering the data set (to include a more stable condition) isn't possible, you can reference the changing condition in the sheet as shown in Figure B.John's record (instead of Bill's) is now highlighted.
But what happens when the condition, rather than the data, changes?
Select the original rule and then click Delete Rule.
If the rule includes other conditions, you'll need to modify it rather than delete it.
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.