Conditional Formatting

Closed
Phil - Dec 12, 2014 at 01:02 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 13, 2014 at 09:19 AM
Hello,

I'm trying to create a table for a field trip. Essentially, I want the students name highlighted based on their homeroom teacher. There are 3 teachers involved, and I can't figure out a formula that will take into account the three name variables. I've tried assigning a number code to each teacher but I can't figure out how to put it all together.

Help!
Phil

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 13, 2014 at 09:19 AM
Phil, Good morning.

There are a lot of way to do this.
As you did not mention the layout of your spreadsheet I made an example for you.

Take a look:
http://speedy.sh/uhu7F/13-12-2014-en-Kioskea-Teachers-Name.xlsx

Is this what you want?
I hope this helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0