Microsoft Works is more than capable of printing in color, and what is displayed in print previous should be printed. My first guess would be that there is a problem with your printer, so you should start in that direction. Open a photo editor (such as Microsoft Paint), draw a cheesy red image, and then print it. If it prints in red, you'll know Works is the problem, otherwise it lies elsewhere.
If the drawing in Paint prints out in greyscale, I'd perform a printer self-test, which is where you disconnect the printer from your computer then have it print out a test page. The instructions vary based on make/model, so we'll need that info before proceeding further down that road. My guess is that either you're out of red ink, the print head is damaged, or the printer software is messed up. The printer self-test should narrow it down to one or two things.
Give us a shout back with the model number.
John
I have created a spreadsheet all in black - have made one line "red" to stand out - it displays on screen in red also in print preview - when I print and I do have printer set to print in all colors - the line that is "red" prints in a lite gray. Works is version 7.0 I have contacted MicroSoft - and they tell me seeing it came installed with my Dell - to contact Dell. Dell will not help over the internet - they request that I call a fee # -
My question is only - is the spreadsheet not capable of printing in 2 colors?
Thanks for anyhelp.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic