You can use Conditional Formatting to set the background color or font color
based upon the value in another cell. This is the Formula Is option. See:

http://www.contextures.com/xlCondFormat02.html
--
Gary's Student
gsnu200708


"CB" wrote:

I have a spreadsheet that I need to fill the interior color of the row red if
column f contains the text red. I need the data in each row to turn red if f
is red for columns a through e and g through m.
Is there an easy way to do this other than sorting/filtering. Is there some
way to do this with VBA?

Any help is appreciated.