LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditionally format points based on a third column hmm Charts and Charting in Excel 3 October 14th 07 09:35 AM
filter or format based on criteria in more than one column tabbicat Excel Worksheet Functions 4 March 13th 07 02:24 PM
Conditional Format a column based on another Karm Excel Discussion (Misc queries) 6 October 30th 06 11:39 AM
Format a column in a table based on the date PPM at Brackmills Excel Discussion (Misc queries) 4 February 15th 06 08:55 PM
New column based on row cell format peteracain Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"