Thread: How can I automatically color a row based on cell content
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote