View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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??