Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How can I automatically color a row based on cell content
0 views
Skip to first unread message
Ed
Jan 7, 2010, 7:31:01 PM1/7/10
to
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.
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
Gord Dibben
Jan 7, 2010, 8:06:56 PM1/7/10
to
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
0 new messages