select all the cells ( ie click the 'box' above the number 1 in the rows and
left of A in the columns

select Format, Conditional formattinf, and use Formula Is
=COUNTIF(1:1,"Y")0

make sure that calculation is automatic


"abc" wrote:

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