select all the cells in the row, and use a formula of =$En="yes", where n is
that row number.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RYD@wolpofflaw" wrote in message
...
I'm trying to figure out how to format all the rows in my file so that
whenever "yes" is listed in Column E, the color of the row is changed to
green. Is there a way to do this so it would apply to the entire page and
not just a singular row?