Conditional Formatting In Excel 2007
 

I'm making a expense table for work that consists of five (5) columns and
would like each row to be a certain color depending the type of expense it
is. For example if Row 2 is for "Gas" than I want the font color to be red.
I know how to do it for a particular row (=C2="Gas" $A$2:$E$2 formatted to
red red text) but was wondering if any way possible to copy this to every row
so the values change to correspond with that particular row. I'm intending
to have four or five conditional formats for each row (supplies, food,
tolls,...) with different font colors for each and can do the same thing for
each new rule. If there is a way to do this it would be a great help.

Thanks