Excel conditional formatting not updating rob dyrdek and chanel dating

Posted by / 02-Mar-2017 20:02

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.

excel conditional formatting not updating-67excel conditional formatting not updating-58excel conditional formatting not updating-20