Conditional programming

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

Could you tell me how i can apply conditional formatting rules to all sheets
in a excel 2007 workbook?

Also, can you copy rules from file to file?

Thanks,
Mark
 
Mark,

Try 1 of these methods

1) Paste Special -> Formats works fine if there are no other formats
for the cell you wish to preserve, such as number formats, borders, or
other aspects of the format you are not adjusting conditionally.

2) CF = Conditional Formatting
Select the cells you want the CF applied to
hold Ctrl, and select at least one cell within the range that is
already contains the CF to be applied
Then Format->Conditional Formatting
Here you will see the conditional formats about to be applied
When you click OK, the CFs will be applied across the whole selection
Then Select just the 'newly' formatted cells and make the desired
changes.
Note that this only works when the cells to wish to copy the CF to
don't already contain conditional formats. If the selected range
contains more that one definition for any of the three rules, the
Conditional Formatting box will show these rules as being blank.

Source Rik @ http://excelusergroup.org/forums/p/497/1443.aspx

Good luck,
Tom
 
Back
Top