I have a worksheet with conditional formatting on certain names by color. How can I remove conditional formatting from the whole worksheet for one particular name? At this point, whenever I type the name the color appears which is what I want. However, when I no longer want it to appear in color anywhere on the worksheet, how can I remove the conditional formatting for just that name? I have tried clicking on Manage Rules and it brings up all the names with the different colors. Although I only want to see the one name and delete the rule from it, I have to scroll through all the names to find the name I want to remove the color from. Any ideas on how I can accomplish this?
