How can I automatically color a row based on cell content

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help to change a cell color based on conditions 1
conditional format of entire row based on a single cell in row 7
Conditional format stoplight based on worst color 3
Sum Column Based on Cell Color 5
Format cell based on cell color 3
Changing entire row based on 1 MAX cell value (Conditional Formatt 2
Function for summing or counting cells based on a specified fill color 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Top