Highlight a row in color

JackStone 

 

See the pictures below and the attached file

 

Hello, you will have to use conditional formmatting.

Assuming you have from column A2 to E100 and in column D2 downward, you have States of New York and Paris in many cells.

If you want to highlight all the rows that contains New York, type in New York in cell F2 and follow the steps below
1. Select all the data from A2 to E100
2. Click on Conditional Formatting and select New Rule
3. Select use a formula to determine which cells to format
4. In the formula box, execute =$D2=$F$2
5. Click on Format and select Fill color of choice.
6. Click OK

All the rows with New York will be highlighted.. If you replace New York with Paris, all the rows with Paris will be highlighted..