View Single Post
  #2   Report Post  
William
 
Posts: n/a
Default

Hi

When you are in the process of applying conditional formatting, you are
looking at the regular "Format Cells" dialog box which is not a dialog box
specifically for conditional formatting. Conditional formatting cannot
change the row height or column width of a cell - hence the font names and
font sizes are greyed out. Presumably heavy borders change the row height or
column width.

For more formatting options, you'll probably need to use code.

--
XL2002
Regards

William



"cbwindycity" wrote in message
...
| When I use conditional formatting in Excel, the font size is grayed out
and
| the options for the border are limited to 5, none of which are the ones I
| need, is there a way to make more formatting options available?