| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
edit CF in Excel 2007
General question - CF Excel 2007 - is there some way to view and/or edit what
conditional formula had been used in a file? It looks like you can only make a new rule or clear rules. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
edit CF in Excel 2007
Try:-
Home tab / Styles group / Conditional Formatting / Manage Rules . . . / Conditional Formatting Rules Manager should launch / then:- - in the Show formatting rules for: drop down select This Worksheet and all the rules for the Worksheet will be displayed OR (to edit) - in the Show formatting rules for: drop down select Current Selection (for example) then click on Edit Rule . . . If my comments have helped please hit Yes. "dp" wrote: General question - CF Excel 2007 - is there some way to view and/or edit what conditional formula had been used in a file? It looks like you can only make a new rule or clear rules. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
edit CF in Excel 2007
Thanks
"trip_to_tokyo" wrote: Try:- Home tab / Styles group / Conditional Formatting / Manage Rules . . . / Conditional Formatting Rules Manager should launch / then:- - in the Show formatting rules for: drop down select This Worksheet and all the rules for the Worksheet will be displayed OR (to edit) - in the Show formatting rules for: drop down select Current Selection (for example) then click on Edit Rule . . . If my comments have helped please hit Yes. "dp" wrote: General question - CF Excel 2007 - is there some way to view and/or edit what conditional formula had been used in a file? It looks like you can only make a new rule or clear rules. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit Links Excel 2007 | Excel Worksheet Functions | |||
| how to edit a drop down box in excel 2007 | Excel Discussion (Misc queries) | |||
| Not able to edit or do anything in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 won't let me edit it at all | Excel Discussion (Misc queries) | |||
| cannot edit macros in excel 2007 | New Users to Excel | |||
Linear Mode
