Looking up data

0

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?

Answer
Discuss

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: 1482) Nov 29, '17 at 5:39 am
Add to Discussion

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login