Color Change Text by type of Entry
 

I am wondering how to cause a Cell to change it's text color without using
the color selection tool. I use Excell to create a 30 person Schedule for
each week of the month. And any time I have new employees, I change the text
to Red to represent newbies.

Program (Excell 2003)

Example:

A1 is Blank and has the Formula in it.
B1-B10 has a list of New Employees.

I use a drop down menu on a seperate sheet that selects the employee's name,
and it is transferd to a schedule for PrintOut.

When the name is transferd (to any cell), it needs to change it's font color
depending on the name that is in the Cell.

So if my Newbie List has Sam, Bill, Jack and Steeve on it and Jack's name
shows up in A1, it should automaticly turn Red to represent a new employee.
-----

I attempted to try and use Conditional Formating to do what I want, but it
dosn't select more than two cells worth of names and dosn't select anything
from different pages.

-Matlock

Color Change Text by type of Entry
 

You can refer to cells on another sheet if you use named ranges, so...
Name the range that contains your list of newbies - call it Newbies.

Now, select the range that needs to be formatted, go to conditional
formatting, select Formula is, and use a formula like

=NOT(ISERROR(MATCH(A4,newbies,0)))

In your version change A4 to reflect the active cell's address

"Matlock" wrote:

I am wondering how to cause a Cell to change it's text color without using
the color selection tool. I use Excell to create a 30 person Schedule for
each week of the month. And any time I have new employees, I change the text
to Red to represent newbies.

Program (Excell 2003)

Example:

A1 is Blank and has the Formula in it.
B1-B10 has a list of New Employees.

I use a drop down menu on a seperate sheet that selects the employee's name,
and it is transferd to a schedule for PrintOut.

When the name is transferd (to any cell), it needs to change it's font color
depending on the name that is in the Cell.

So if my Newbie List has Sam, Bill, Jack and Steeve on it and Jack's name
shows up in A1, it should automaticly turn Red to represent a new employee.
-----

I attempted to try and use Conditional Formating to do what I want, but it
dosn't select more than two cells worth of names and dosn't select anything
from different pages.

-Matlock

Color Change Text by type of Entry
 

That is exactly what I needed. Thanks. -Thumbs up!-