How can I automatically color a row based on cell content
 

I'd like to automatically color code an entire row of a spreadsheet I'm
creating based on the entry of a single cell. The cells with the entries are
all in the same column in no particular order. Example, type in 'SS' turns
the row red, 'ST' turns it green.

Thank You

Ed

How can I automatically color a row based on cell content
 

Select the row.

FormatConditional FormattingFormula is:

=$A1="SS" format to red

AddCondtion2

=$A1="ST" format to green.

Excel 2007 very similar except uses "rules" instead of "conditions"


Gord Dibben MS Excel MVP

On Thu, 7 Jan 2010 16:31:01 -0800, Ed wrote:

I'd like to automatically color code an entire row of a spreadsheet I'm
creating based on the entry of a single cell. The cells with the entries are
all in the same column in no particular order. Example, type in 'SS' turns
the row red, 'ST' turns it green.

Thank You

Ed