Forum Discussion
JackStone
Mar 26, 2020Copper Contributor
Highlight a row in color
I'm really looking for someone to walk me through the steps to highlight a row in color on an Excel spreadsheet. Cant seem to do it with on line tips
Abiola1
Mar 26, 2020MVP
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..
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..