Changing a row to a different color
Posted by Gina on October 30, 2001 9:12 AM
I keep track of new employees at our organization. There are several things that need to be done for them. I have a VERY basic excel spreadsheet set up to keep track of everything that needs to be done. I would like to see if there is a formula or something out there that will change the color of my row (or even a word) once I indicate that the process is complete for that person. I'd really appreciate any suggestions you could offer. Thanks!
Posted by Aladin Akyurek on October 30, 2001 9:53 AM
Gina,
I imagine you have a row per employee. A specific cell in a employee row has something in it indicating that the process is complete.
Supposing that the first employee is in row 1 and the cell that you use for marking up the process is F1. Lets say that you use an X as mark.
Select all employee rows via the row indicator (where you see the row numbers).
Activate Format|Conditional Formatting.
Select "Formula Is" for Condition 1.
Enter as formula
=F1="X"
Activate Format.
Select a color on the Patterns tab.
Click OK.
Click OK.
Aladin
======
Posted by Gina on October 30, 2001 11:23 AM
Aladin,
That worked perfectly! Thank you so much for your help!
Gina
