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


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


Activate Format.
Select a color on the Patterns tab.
Click OK.
Click OK.



Posted by Gina on October 30, 2001 11:23 AM

That worked perfectly! Thank you so much for your help!