How can I automatically color a row based on cell content

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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
 
Select the row.

Format>Conditional Formatting>Formula is:

=$A1="SS" format to red

Add>Condtion2

=$A1="ST" format to green.

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


Gord Dibben MS Excel MVP
 
Back
Top