Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Colors
In Excel 2007, need to differentiate rows by color.
In column M, "H" = Color 1 "A" = Color 2 "P" = Color 3 "L" = Color 4 I will be printing data from the spreadsheet, so I'd like to use lighter shades of colors rather than the bright, primary colors that will show up dark on printed pages. Thanking you in advance. Betty |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Colors
Yes, those are letters that are found in that column. The rows need to be
colored based on the letters in column M. "Simon Lloyd" wrote: Betty, i don't understand when you say "H", "A"....etc do you mean if the letter is found in column M? Betty K;578287 Wrote: In Excel 2007, need to differentiate rows by color. In column M, "H" = Color 1 "A" = Color 2 "P" = Color 3 "L" = Color 4 I will be printing data from the spreadsheet, so I'd like to use lighter shades of colors rather than the bright, primary colors that will show up dark on printed pages. Thanking you in advance. Betty -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=159853 Microsoft Office Help . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
2007 Colors - I want 2003 Colors | Excel Discussion (Misc queries) | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) |