Display Cond. Format Formulas
 

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.

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.