hi all

i'd like to show a whole row in red color if one cell of the row
contains a value e.g. "y"

i tried conditional formatting bu it only works on single cells.

Any idea on how to do this?

thanks