Display Cond. Format Formulas

D

dblair3270

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.
 
J

Jim Rech

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
| 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.
 
Top