Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Change Text by type of Entry
That is exactly what I needed. Thanks. -Thumbs up!-
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change the color/type of the borders I put on cells? | Excel Discussion (Misc queries) | |||
using data entry to change a fill color | Excel Worksheet Functions | |||
How do I change text from all caps to normal type? | Excel Worksheet Functions | |||
How do I change cell color upon entry, and exit? | Excel Worksheet Functions | |||
automatically change text case on entry | Excel Discussion (Misc queries) |