Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format one column based on another?
I have a spread sheet that we track work packages on as they travel through
the job process. We track by Work order number listed in column A and all the steps are listed in the columns out to the right. The dates are added in the corresponding column as the packet travels through the various steps. I would like to highlight/fill the work order number in different colors as it is entered in the columns to the right. Is that possible? If so, how in the heck do you do it?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format one column based on another?
You would normally do it using Conditional Formatting.
How many processes do you have to the right? Excel 2003 and earlier had a limit of 3 conditional formats, so if you have more than this you will need a macro (or Bob Phillips CFPlus add-in). Hope this helps. Pete "Needaclerk" wrote in message ... I have a spread sheet that we track work packages on as they travel through the job process. We track by Work order number listed in column A and all the steps are listed in the columns out to the right. The dates are added in the corresponding column as the packet travels through the various steps. I would like to highlight/fill the work order number in different colors as it is entered in the columns to the right. Is that possible? If so, how in the heck do you do it?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally format points based on a third column | Charts and Charting in Excel | |||
filter or format based on criteria in more than one column | Excel Worksheet Functions | |||
Conditional Format a column based on another | Excel Discussion (Misc queries) | |||
Format a column in a table based on the date | Excel Discussion (Misc queries) | |||
New column based on row cell format | Excel Discussion (Misc queries) |