I have a timesheet worksheet that has a column formatted "if cell = clientx then blue or if cell = client y then red....."
There are 120 cells covered by this rule.
One of the my clients has changed their name, and from what I have seen the only way to change the name in all instances is to edit them individually in "Manage Rules" in conditional formatting. Is there an easier way?
If they were formula's I'd just use search and replace