Santa's List: Conditional Formatting Entire Row based columns in another sheet.

[jeffcoleky]

Title says it all. I want to do Format an Entire Row IF the data in Column A of that row contains an exact match to a list of names in another sheet. (we'll use Santa's Christmas list as an example)

I want the people in the "List" sheet, as they are categorized, to determine the row's background color of the names on Sheet 1 (Names). Green Background if they're Nice, Red Background if Naughty.

Names should be able to be added and removed from Sheet 2 at any time.

Sheet 1: "Names"
Bob <- (Entire Row has Green background)
Easter Bunny <- (Entire Row has Red background)
Pat <- (Entire Row has Red background)
Sam <- (Entire Row has Green background)
George <- (Entire Row has Green background)
You <- (Entire Row has Red background)


Sheet 2: "List"

Column A1: Nice
Bob
Sam
George

Column A2: Naughty
You
Pat
Easter Bunny

 

[asad]

I had the same result EXCEPT mine shows George as being naughty. How Strange?! I did exactly what you said too... and he's in the right column.

It can't be. Try deleting the name and retyping it in both Sheets.

Asad

 

[asad]

However, i want it to automatically highlight the row, not just the one cell.

Currently, the columns range from Column "A" thru Column "AG" but that may get wider over time. In addition, those columns have other conditional formatting in them.

For extending it to other columns in same row, just copy the cell with CF and paste special > format only in all the other cells in same row.

If you have Excel 2003, you can have only three CFs. For more than that, you will have to have VBA.

Asad

 

[jeffcoleky]

For extending it to other columns in same row, just copy the cell with CF and paste special > format only in all the other cells in same row.

If you have Excel 2003, you can have only three CFs. For more than that, you will have to have VBA.

Asad

Thank you both, it's working like a champ. Santa is fired, i'm taking over.