Thanks for the suggestions folks. I've tried Frank Cabel & Bob Phillips
CFPlus add in, and it's great file. Only thing is that it won't allow for
global formatting in a column of cells for more than one sheet, and it would
take forever to set up 8 formatting instructions for each workbook, going
sheet by sheet.

Bob

"Peo Sjoblom" wrote in message
...
Depending on what data you are using there are ways

http://www.mcgimpsey.com/excel/conditional6.html


or get an add-in

http://www.xldynamic.com/source/xld.....Download.html

or get the next version of Excel which has no limits except system memory


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Bob Smith" wrote in message
ink.net...
Another question for you mavens. I'd like to use conditional formatting
to color cell fonts s which are within a certain range. As it stands now,
I see I can only set three sets of ranges.

Is there a way to tweak the Conditional Formatting feature to go to at
least 7 sets of ranges?

Is there any other solution any of you folks have?

TIA,

Bob