Different Colors for Rows With Key Words

**KGBerry** · 06-20-2012, 05:43 PM

Howdy,

I have four teams that have specific colors that define them. I am trying to have ecxel automatically fill in the row that has that teams name and all the information within that row to have a certain color that defines that team. How would I do that? Doing this manually takes forever.

Thanks!

**Mark Gordon** · 06-20-2012, 08:25 PM

Hi
The following works for me.
Suppose your names of the teams were "Blue" and "Yellow", and the names of the teams could be found in column A. To make blue team rows blue, the steps are as follows:
1. Select all the data
2. Click on conditional formatting (in the home tab)
3. Click on new rule
4. Click on "Use a formula...."
5. enter this formula in the box =$a1="Blue"
6. Click on format and choose a font or a fill color
7. Click OK
8 . Click OK

Repeat these steps for the other teams

**FDibbins** · 06-20-2012, 09:51 PM

@ Mark that will just make that 1 cell change color

to make the entire row change color based on the team's name, try using this formula, in the same way that Mark suggested...

=INDIRECT("D"&ROW())="Blue" where D is the column the team color is in - change this if needed.

then repeat that with "new rule" for the other teams

let me know how this works out for you?