How do I use conditional formatting on all rows based on data
 

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?

How do I use conditional formatting on all rows based on data
 

Highlight the range you want the formatting to apply to.
Select Format Conditional Formatting
Select Formula is
Enter =$E1="yes" (assuming your range starts in row 1)
Click on Format
Select your green background fill
OK you way out


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=483992

How do I use conditional formatting on all rows based on data
 

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?