View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Can't change font on conditional formatting

That is correct. My take is that Conditional formatting does not support
changing anything that might change the overall format of the worksheet.
Changing the font could result in data being cut off unless the column is
made wider because the characters in the font might require more space (as
an example). Thus size is not an option either.

--
Regards,
Tom Ogilvy

"faustino Dina" wrote in message
...
Hi,

I'm playing with the Conditional Formatting of a cell. I need to change

the
font according to the value of the cell. The problem is the font selector

is
disabled on the conditional format dialog. Is not possible to change the
font when conditional formatting the cell or may be I'm missing something?

Thanks in advance

--
Faustino Dina
--------------------------------------------------------
If my email address starts with two 'f'
drop the first 'f' when mailing me.