Yakuzayal

 In the Format Cells dialog box, switch to the Fill tab and select the color of your choice, the reddish color in our case, and click OK Now you are back to the New Formatting Rule window and the preview of your format changes is displayed in the Preview box If everything is Okay, click the OK buttonThis video explains how to highlight duplicate values in the same column in a different colour It demonstrates two methods, one of which highlights the fir Have a formula that allows me to match the fill color of one cell to another, with out conditional formatting, so it can also be copied and pasted to other areas/sheets For example, have that column B cells match the fill color in column A and that column B cells can easily be copied and pasted (with fill color) to another area/sheet How To Count Duplicate Values In Excel Excelchat Excel color cell if duplicate