ExcelBanter - 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

.