ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Font and Size Disabled in Conditional Formatting ?? (https://www.excelbanter.com/excel-worksheet-functions/213596-font-size-disabled-conditional-formatting.html)

monir

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.

T. Valko

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.




monir

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.





T. Valko

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.







monir

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.







Chip Pearson

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.


monir

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.




All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com