Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format to display date as Quarter | Excel Discussion (Misc queries) | |||
Accounting format now no longer display negative figures in ( )'s | Excel Discussion (Misc queries) | |||
How do I format the date in a footer to display the month in lett. | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |