edit CF in Excel 2007

  • Thread starter Thread starter dp
  • Start date Start date
D

dp

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

trip_to_tokyo said:
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.
Click to expand...
 
Back
Top