Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Font Vs Normal Font | Excel Discussion (Misc queries) | |||
Changing font color if conditions are met | Excel Worksheet Functions | |||
Excel 2007 Conditional Font Color How To? | Excel Discussion (Misc queries) | |||
can i use format (font color) in an if argument? | Excel Discussion (Misc queries) | |||
FONT COLOR FORMAT | Excel Discussion (Misc queries) |