If Cell equals certain text, color entire row orange

[ScabbyDog]

If column Y cell i, has value "P" then I want the entire row i, to be automatically colored orange. Can I do this through a macro?

[JosephP]

you can do it without a macro using conditional formatting

[nathansav]

yes, it will be on the worksheet_change event in the sheet, and you would say something like

Please Login or Register  to view this content.

[ScabbyDog]

Can you talk me through how I would conditionally format it Joe?

[abduljaleel.mca]

u can also use the attached macro....

[JosephP]

1. select the data columns you want highlighted
2. home tab, conditional formatting, new rule...
3. 'use a formula to determine which cells to format...'
4. enter:
=$Y2="p"
as the formula (assuming active cell in row 2-if not change the row number)
5. choose the formatting you want