Link to home
Create AccountLog in
Avatar of Janice Smith
Janice SmithFlag for United States of America

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
Avatar of Janice Smith
Janice Smith
Flag of United States of America image

ASKER

Oops...here's the attachment.
EE-Sample-Workbook.xls
Avatar of Ejgil Hedegaard
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
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
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Chosen answer takes carer of the original requirement.