View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default Display Cond. Format Formulas

It would be nice...but I don't know if this is available

It's not. About all you can do is speed up the process of opening the
dialog slightly with a macro. You could attach this macro to a toolbutton
or a shortcut key...

Sub aa()
Application.Dialogs(xlDialogConditionalFormatting) .Show
End Sub

--
Jim
"dblair3270" wrote in message
...
| Is there a way to display a cell's conditional format formula w/o actually
| going through the menu to look at it? I need a way to quickly tell what
| formula a cell is using for conditional formatting. It would be nice if
you
| could hover your mouse over the cell and the formula would be diplayed
| (similar to a comment), but I don't know if this is available.
|
| Thanks.