Conditional formatting issue

[Vidcapper]

I've been trying to set the font/text size of a cell based on the value
in another, but the option to do so is greyed out. Any idea why I can't
seem to do this?

(Excel 2010)

 

[Claus Busch]

Hi Paul,

Am Mon, 12 Jan 2015 07:13:03 +0000 schrieb Vidcapper:

I've been trying to set the font/text size of a cell based on the value
in another, but the option to do so is greyed out. Any idea why I can't
seem to do this?

with CF you only can change to bold, italian and so on or change the
font colorof you can add underline or strikethrough.


Regards
Claus B.

 

[Claus Busch]

Hi again,

Am Mon, 12 Jan 2015 08:18:05 +0100 schrieb Claus Busch:

with CF you only can change to bold, italian and so on or change the
font colorof you can add underline or strikethrough.

font name or font size cannot be changed with CF


Regards
Claus B.

 

[Vidcapper]

Hi again,

Am Mon, 12 Jan 2015 08:18:05 +0100 schrieb Claus Busch:


font name or font size cannot be changed with CF

OK, fair enough - is there another way of doing it, though?

 

[Claus Busch]

Hi John,

Am Mon, 12 Jan 2015 16:23:58 +0000 schrieb Vidcapper:

OK, fair enough - is there another way of doing it, though?

you could do it with VBA


Regards
Claus B.

 

[Vidcapper]

Hi John,

Am Mon, 12 Jan 2015 16:23:58 +0000 schrieb Vidcapper:


you could do it with VBA

Not really that crucial, just a cosmetic nicety - but thanks anyway.