Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 215
Default Font and Size Disabled in Conditional Formatting ??

Hello;

Are Font:, Size:, Superscript and Subscript always disabled in Conditional
Formatting::Format (XL 2003) ??
If this is the case, then why they are there in the 1st place ??

Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Font and Size Disabled in Conditional Formatting ??

Are Font:, Size:, Superscript and Subscript always
disabled in Conditional Formatting::Format (XL 2003)


Yes

If this is the case, then why they are there in the 1st place


It's the same user form as FormatCellsFont tab. They probably figured that
since they already had a user form for this it would be easier to use the
same one and just disable those items when called for conditional
formatting.



--
Biff
Microsoft Excel MVP


"monir" wrote in message
...
Hello;

Are Font:, Size:, Superscript and Subscript always disabled in Conditional
Formatting::Format (XL 2003) ??
If this is the case, then why they are there in the 1st place ??

Thank you.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 215
Default Font and Size Disabled in Conditional Formatting ??

Hi Biff;

Thank you kindly for the confirmation and for the explanation. It makes
sense!

PS. I've an interesting Excel thread: "Transfer of Multiple-Font Cells ??"
in another forum with no resolution yet. Can I post it here without being
accused of cross-posting ?? Someone in this DG might have the answer!

Regards.

"T. Valko" wrote:

Are Font:, Size:, Superscript and Subscript always
disabled in Conditional Formatting::Format (XL 2003)


Yes

If this is the case, then why they are there in the 1st place


It's the same user form as FormatCellsFont tab. They probably figured that
since they already had a user form for this it would be easier to use the
same one and just disable those items when called for conditional
formatting.



--
Biff
Microsoft Excel MVP


"monir" wrote in message
...
Hello;

Are Font:, Size:, Superscript and Subscript always disabled in Conditional
Formatting::Format (XL 2003) ??
If this is the case, then why they are there in the 1st place ??

Thank you.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Font and Size Disabled in Conditional Formatting ??

Yeah, you can post it to this newsgroup but you should start a new post
since it's a different topic. If I were you I'd post it in a new thread and
explain that you've posted the question already in another forum but haven't
received a solution.

--
Biff
Microsoft Excel MVP


"monir" wrote in message
...
Hi Biff;

Thank you kindly for the confirmation and for the explanation. It makes
sense!

PS. I've an interesting Excel thread: "Transfer of Multiple-Font Cells ??"
in another forum with no resolution yet. Can I post it here without being
accused of cross-posting ?? Someone in this DG might have the answer!

Regards.

"T. Valko" wrote:

Are Font:, Size:, Superscript and Subscript always
disabled in Conditional Formatting::Format (XL 2003)


Yes

If this is the case, then why they are there in the 1st place


It's the same user form as FormatCellsFont tab. They probably figured
that
since they already had a user form for this it would be easier to use the
same one and just disable those items when called for conditional
formatting.



--
Biff
Microsoft Excel MVP


"monir" wrote in message
...
Hello;

Are Font:, Size:, Superscript and Subscript always disabled in
Conditional
Formatting::Format (XL 2003) ??
If this is the case, then why they are there in the 1st place ??

Thank you.






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 215
Default Font and Size Disabled in Conditional Formatting ??

Biff;

Will do just that in the next couple of hours.
I'll keep the same Subject Title: "Transfer Multiple-Font Cells ??"

Thanks again.


"T. Valko" wrote:

Yeah, you can post it to this newsgroup but you should start a new post
since it's a different topic. If I were you I'd post it in a new thread and
explain that you've posted the question already in another forum but haven't
received a solution.

--
Biff
Microsoft Excel MVP


"monir" wrote in message
...
Hi Biff;

Thank you kindly for the confirmation and for the explanation. It makes
sense!

PS. I've an interesting Excel thread: "Transfer of Multiple-Font Cells ??"
in another forum with no resolution yet. Can I post it here without being
accused of cross-posting ?? Someone in this DG might have the answer!

Regards.

"T. Valko" wrote:

Are Font:, Size:, Superscript and Subscript always
disabled in Conditional Formatting::Format (XL 2003)

Yes

If this is the case, then why they are there in the 1st place

It's the same user form as FormatCellsFont tab. They probably figured
that
since they already had a user form for this it would be easier to use the
same one and just disable those items when called for conditional
formatting.



--
Biff
Microsoft Excel MVP


"monir" wrote in message
...
Hello;

Are Font:, Size:, Superscript and Subscript always disabled in
Conditional
Formatting::Format (XL 2003) ??
If this is the case, then why they are there in the 1st place ??

Thank you.








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7,247
Default Font and Size Disabled in Conditional Formatting ??

And the reason behind disabling those items for Conditional Formatting
was that they (MS) assumed that changing attribute that would modify
the column width or row height should not be allowed in CF. Not
everyone agrees with this, but there it is.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 13 Dec 2008 16:43:19 -0500, "T. Valko"
wrote:

Are Font:, Size:, Superscript and Subscript always
disabled in Conditional Formatting::Format (XL 2003)


Yes

If this is the case, then why they are there in the 1st place


It's the same user form as FormatCellsFont tab. They probably figured that
since they already had a user form for this it would be easier to use the
same one and just disable those items when called for conditional
formatting.

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 215
Default Font and Size Disabled in Conditional Formatting ??

Chip;

Thanks for providing an alternative explanation.

Please whenever your time allows look at my recent Thread in this DG:
"Transfer Multiple-Font Cells ??".
It can't be that difficult ? or Is it ?

Kind regards.


"Chip Pearson" wrote:

And the reason behind disabling those items for Conditional Formatting
was that they (MS) assumed that changing attribute that would modify
the column width or row height should not be allowed in CF. Not
everyone agrees with this, but there it is.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 13 Dec 2008 16:43:19 -0500, "T. Valko"
wrote:

Are Font:, Size:, Superscript and Subscript always
disabled in Conditional Formatting::Format (XL 2003)


Yes

If this is the case, then why they are there in the 1st place


It's the same user form as FormatCellsFont tab. They probably figured that
since they already had a user form for this it would be easier to use the
same one and just disable those items when called for conditional
formatting.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Font Color Based on Conditional Formatting tj Excel Worksheet Functions 8 October 11th 08 02:08 AM
Why is conditional formatting disabled(!)? [email protected] Excel Discussion (Misc queries) 4 April 5th 07 02:42 PM
Font size in conditinal formatting GDC Excel Discussion (Misc queries) 0 October 18th 05 06:38 PM
Conditional formatting font Harley Excel Discussion (Misc queries) 2 June 28th 05 06:43 PM
why cant i change font size when i use conditional formatting? cbwindycity Excel Discussion (Misc queries) 1 January 6th 05 10:45 PM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"