If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Format Font Color for more than 3 conditions
A B J K
7 Date Store # Date Store # 8 9 01/01/2009 1122 10 01/02/2009 3666 11 01/03/2009 1121 12 01/03/2009 2586 13 01/03/2009 4558 14 01/14/2009 6687 15 01/15/2009 N/A 16 01/15/2009 3652 17 01/16/2009 Sam If any cell in column b =1122 then FONT COLOR is a color off the font chart that I choose and every row in the worksheet with that store # will be that color. I need this for ever item listed in column "B" above. Each Store # will have a different color. Furthermore, I need that same function sent to several other worksheet in the workbook. I think that is =b,etc. Again, I need this for every store # in column "B" listed above. Can I do this as a column or do I have to start at B1 or can I choose column "B"? If I have to choose a cell pic one in column "B" that does not have a heading? I know that to put the same information in cells "J" & "K" of the same worksheet then that cell then format painter, correct? If you have answers please help. I already have almost 800 rows that need to be formated in column "B" to include in at least 6 other worksheets in the workbook. -- abusymomforever |
#2
|
|||
|
|||
Conditional Format Font Color for more than 3 conditions
Excel 2003 and earlier - You can have formats for a maximum of three
different conditions (four if you count the default format)...[Excel 2007 does not have this limitation.] You can conditionally format B1 and then Paint the whole Col or Select the whole column and then enter the formula for FORMULA is =A1=1122 and then paint the format over other columns... You need to use a macro if you want to color more than three(plus one) different ways... "abusymomforever" wrote: A B J K 7 Date Store # Date Store # 8 9 01/01/2009 1122 10 01/02/2009 3666 11 01/03/2009 1121 12 01/03/2009 2586 13 01/03/2009 4558 14 01/14/2009 6687 15 01/15/2009 N/A 16 01/15/2009 3652 17 01/16/2009 Sam If any cell in column b =1122 then FONT COLOR is a color off the font chart that I choose and every row in the worksheet with that store # will be that color. I need this for ever item listed in column "B" above. Each Store # will have a different color. Furthermore, I need that same function sent to several other worksheet in the workbook. I think that is =b,etc. Again, I need this for every store # in column "B" listed above. Can I do this as a column or do I have to start at B1 or can I choose column "B"? If I have to choose a cell pic one in column "B" that does not have a heading? I know that to put the same information in cells "J" & "K" of the same worksheet then that cell then format painter, correct? If you have answers please help. I already have almost 800 rows that need to be formated in column "B" to include in at least 6 other worksheets in the workbook. -- abusymomforever |
#3
|
|||
|
|||
Conditional Format Font Color for more than 3 conditions
Hi,
Here is some sample code which you need to modify to meet your conditons: Sub ColorCoding() Dim cell As Range For Each cell In Selection With cell.EntireRow.Font Select Case cell Case 0 To 99 .ColorIndex = 38 Case 100 To 199 .ColorIndex = 44 Case 200 To 299 .ColorIndex = 36 Case 300 To 399 .ColorIndex = 35 Case 400 To 499 .ColorIndex = 34 Case 500 To 599 .ColorIndex = 37 Case 600 To 699 .ColorIndex = 39 Case 700 To 799 .ColorIndex = 7 Case 800 To 899 .ColorIndex = 4 Case Else .ColorIndex = 47 End Select End With Next cell End Sub You will change my entries like 800 to 899 to read 3652 and so on. -- If this helps, please click the Yes button Cheers, Shane Devenshire "abusymomforever" wrote: A B J K 7 Date Store # Date Store # 8 9 01/01/2009 1122 10 01/02/2009 3666 11 01/03/2009 1121 12 01/03/2009 2586 13 01/03/2009 4558 14 01/14/2009 6687 15 01/15/2009 N/A 16 01/15/2009 3652 17 01/16/2009 Sam If any cell in column b =1122 then FONT COLOR is a color off the font chart that I choose and every row in the worksheet with that store # will be that color. I need this for ever item listed in column "B" above. Each Store # will have a different color. Furthermore, I need that same function sent to several other worksheet in the workbook. I think that is =b,etc. Again, I need this for every store # in column "B" listed above. Can I do this as a column or do I have to start at B1 or can I choose column "B"? If I have to choose a cell pic one in column "B" that does not have a heading? I know that to put the same information in cells "J" & "K" of the same worksheet then that cell then format painter, correct? If you have answers please help. I already have almost 800 rows that need to be formated in column "B" to include in at least 6 other worksheets in the workbook. -- abusymomforever |
#4
|
|||
|
|||
Conditional Format Font Color for more than 3 conditions
Unfortunately I am using Excel 2003. Thanks for the input I'll give it a try.
-- abusymomforever "Sheeloo" wrote: Excel 2003 and earlier - You can have formats for a maximum of three different conditions (four if you count the default format)...[Excel 2007 does not have this limitation.] You can conditionally format B1 and then Paint the whole Col or Select the whole column and then enter the formula for FORMULA is =A1=1122 and then paint the format over other columns... You need to use a macro if you want to color more than three(plus one) different ways... "abusymomforever" wrote: A B J K 7 Date Store # Date Store # 8 9 01/01/2009 1122 10 01/02/2009 3666 11 01/03/2009 1121 12 01/03/2009 2586 13 01/03/2009 4558 14 01/14/2009 6687 15 01/15/2009 N/A 16 01/15/2009 3652 17 01/16/2009 Sam If any cell in column b =1122 then FONT COLOR is a color off the font chart that I choose and every row in the worksheet with that store # will be that color. I need this for ever item listed in column "B" above. Each Store # will have a different color. Furthermore, I need that same function sent to several other worksheet in the workbook. I think that is =b,etc. Again, I need this for every store # in column "B" listed above. Can I do this as a column or do I have to start at B1 or can I choose column "B"? If I have to choose a cell pic one in column "B" that does not have a heading? I know that to put the same information in cells "J" & "K" of the same worksheet then that cell then format painter, correct? If you have answers please help. I already have almost 800 rows that need to be formated in column "B" to include in at least 6 other worksheets in the workbook. -- abusymomforever |
Thread Tools | |
Display Modes | |
|
|