Hi Guys!

I was wondering if you could help me out with a little problem i'm having with Excel.

I have two sheets. One contains two columns; hotel name and rating. The rating is a percentage and if the percantage is less than 30% the row turns red, 31 - 70% is yellow and 71%+ is green.

The second sheet has lots of columns, they include the same hotel name column as in the first sheet but not the rating column. The sheet has thousands of rows and each hotel name may be duplicated lots of times but with different data in the other columns.

I would like some way of taking the name from the hotel name column of the first sheet, seeing what colour it is and then excel automatically making any row which contains the same hotel name the same colour as it is in the first sheet.

For example: Sheet 1 =

Hilton Hotel, 90% (the row is green)
Poor Hotel, 20% (the row is red)

Sheet 2 =

Hilton Hotel, 2 nights, Breakfast included (row automatically turns green)
Hilton Hotel, 1 night, Breakfast included (row automatically turns green)
Poor Hotel, 2 nights, Room Only (row automatically turns red red)
Hilton Hotel, 7 nights, Room Only (row automatically turns green)

I hope that what I am asking is possible and that somebody can help.

Thank you for taking the time to read this post and I look forward to a solution!

Matt