Then combine the formats!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NathanS" wrote in
message ...

I know how to make alternating color backgrounds........ my problem is I
was wantnig to combine things...

1. 70%
2. 75%
3. 81%
4. 83%
5. 73%
6. 89%

I want background to be grey lines 2,4,6

I want the foreground (text color) to be *Black * and on lines 3,4,6 to
be *Red*


--
NathanS
------------------------------------------------------------------------
NathanS's Profile:
http://www.excelforum.com/member.php...o&userid=26288
View this thread: http://www.excelforum.com/showthread...hreadid=395718