Format one column based on another?

N

Needaclerk

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??
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count number of cells and total in one column, based on another column suffix 5
Show date based on conditions 0
Count nonblank cells based on another column 1
2 criteria 1
Format cell based on cell color 3
Format a cell based on incremental numbers 3
Adding certain cells in one column 4
Counting depending on another column 4

Top