| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Format text based on which of several unique lists the value belongs to?
Hello,
I have several (5 or so) lists of product lines, each of which makes up a product family (from 5 to 10 product lines per product family). I would like to assign a font color or cell shading to text cells in a table of product lines, based upon which product family the product line belongs to. Anyone know a way to automate this? Thanks. Troy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
| Text to Numeric format | Excel Discussion (Misc queries) | |||
| how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
| conditional format for text | Excel Worksheet Functions | |||
Threaded Mode
