Some Conditional Formats Not Available

T

Tom Nichol

I am using Excel 2000 on a network. Conditional Formatting for font typeface and size are not available under any circumstances. Has anyone else had this problem and/or identified the cause and/or remedy? Also the border options are severely limited (no bold or double lines). Is this normal, or is there something wrong with our Excel installation here?
 
F

Frank Kabel

Hi
this is normal!
If you need these kind of formats you have to use VBA

--
Regards
Frank Kabel
Frankfurt, Germany

Tom Nichol said:
I am using Excel 2000 on a network. Conditional Formatting for font
typeface and size are not available under any circumstances. Has
anyone else had this problem and/or identified the cause and/or remedy?
Also the border options are severely limited (no bold or double
lines). Is this normal, or is there something wrong with our Excel
installation here?
 
B

Bob Phillips

No that just seems to be a limitation of CF. Seems odd, but it is.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Tom Nichol said:
I am using Excel 2000 on a network. Conditional Formatting for font
typeface and size are not available under any circumstances. Has anyone
else had this problem and/or identified the cause and/or remedy? Also the
border options are severely limited (no bold or double lines). Is this
normal, or is there something wrong with our Excel installation here?
 
Top