Have a look here
http://www.mvps.org/dmcritchie/excel....htm#grayscale
--
Don Guillett
SalesAid Software

"Peter Longstaff" wrote in message
. ..
Hi All,

I want to print some lines in a lighter colour (i.e. gray as appossed to
black) depending upon a given condition being true. my code works fine on
a
color printer as I use something like :

if(a b)
font.SetColor(_variant_t(RGB(192,192,192))); // Gray

On a mono printer it only prints the black text. What I really need is to
tell the printer to print in grayscale!


Can someone tell me how to do this?

TIA Peter