MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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