asked on Excel 2010 - Conditional Formatting for Duplicate Values Across Worksheets
Hello Experts,
Is there a formula or conditional formatting that can be applied to worksheets in a workbook that will change the font to a different color if the values in any of the cells or columns in one worksheet appear on any other worksheet in the work book? I've attached a simple workbook just in case you can add the formula to the workbook as an example of how it's done.
Thank you
Is there a formula or conditional formatting that can be applied to worksheets in a workbook that will change the font to a different color if the values in any of the cells or columns in one worksheet appear on any other worksheet in the work book? I've attached a simple workbook just in case you can add the formula to the workbook as an example of how it's done.
Thank you
Microsoft ExcelSpreadsheets
Last Comment
Subodh Tiwari (Neeraj)
I don't think it is possible to look at entire worksheets without VBA.
For single columns like the sample, conditional formatting and named ranges can do it.
Red means the name is on both sheets City2 and City3, green on City2, and blue on City3.
It is not clear what you mean by "values in any of the cells or columns", so this is for single cell formatting.
EE-Sample-Workbook.xls
For single columns like the sample, conditional formatting and named ranges can do it.
Red means the name is on both sheets City2 and City3, green on City2, and blue on City3.
It is not clear what you mean by "values in any of the cells or columns", so this is for single cell formatting.
EE-Sample-Workbook.xls
ASKER
Thank you.
I mean if any values in column A on any of the worksheets appear in the same column on any other worksheet, then the formatting should be applied.
EE-Sample-Workbook-2.xls
I mean if any values in column A on any of the worksheets appear in the same column on any other worksheet, then the formatting should be applied.
EE-Sample-Workbook-2.xls
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Chosen answer takes carer of the original requirement.
EE-Sample-Workbook.xls