| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically color a cell based upon a condition being | Excel Worksheet Functions | |||
| how to change a cell color based on its content using macro? | New Users to Excel | |||
| automatically format cell based on content of another cell | Excel Worksheet Functions | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
| how to change the raw height automatically based on the content si | Excel Discussion (Misc queries) | |||
Hybrid Mode
