Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dblair3270
 
Posts: n/a
Default 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   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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format to display date as Quarter Christine Excel Discussion (Misc queries) 5 October 19th 05 03:30 AM
Accounting format now no longer display negative figures in ( )'s R. Earl R. Excel Discussion (Misc queries) 2 October 16th 05 09:56 PM
How do I format the date in a footer to display the month in lett. RBono Excel Discussion (Misc queries) 1 February 10th 05 01:59 AM
Min/Max formulas using cells with date format WDS2000 Excel Worksheet Functions 1 February 7th 05 06:03 PM
Empty Cells, Spaces, Cond Format? Ken Excel Discussion (Misc queries) 3 December 4th 04 04:47 PM


All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"