Can the default Duplicate Values Color be changed? My current color is Light Red Fill w/Dark Red Text. I know how to manually do it, but it takes several more clicks, but changing the default would help.
Can the default Duplicate Values Color be changed? My current color is Light Red Fill w/Dark Red Text. I know how to manually do it, but it takes several more clicks, but changing the default would help.
General Answer: You could set up a conditional formatting rule and set any colour you like.
if you want anything more specific, provide a sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
To make sure we are on the same track: From the Home Tab/Conditional Formatting/Highlight Cell Rules/Duplicates. I only want to know if the default that shows up first can be changed without selecting one of the options or the Custom choice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks