If in sheet 1 i have a list such as:
Smith
Jones
Williams
Harris
and then I enter into colum A in sheet 2 any of the names on that list, can I automatically have the name in the list in sheet 1 automatically change font colour?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Looking up data
0
Discussion
Please don't forget to select the answer that worked for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1989) Nov 29, '17 at 5:39 am
Answers
0
You can do this with conditional formatting. Apply this formula to cells you wish to have coloured (Use a formula to determine which cells to format).
=COUNTIF(Sheet2!$A:$A,$A2)In this example the cell to be coloured is Sheet1!(A2) and it is presumed that you will possibly enter the same name anywhere in Sheet2!(Column A). A2 will assume the specified format (font colour) when the name is entered at least once.