Hi,
Is there any way to change the duplicate highlighting (by default its dark red) color to any other colour by default.
There is an option to change in the tab CF>Highlight Cell Rules>Duplicate values but we need to change it every time whenever i m working with different excel or different columns.
Bookmarks