Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using conditional formatting in Excel 2007 | New Users to Excel | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) |