FSt1 wrote:
hi
conditional formating can work for the whole row.
high light the row. i recommend that you just high light the part of the row
that contains data and not the entire row.
assuming row 3.......
enter this...
formula is.......=$A$3="Y"..........format red.

That works thanks. How can I apply that to all the rows so that any row
where the cell in column A has a "Y" gets colored in red?

Thanks