Hi there,

thanks for your reply - i am still confused tho. When i select the group as
you suggest, the conditional formatting button is greyed out and disabled!?

Any ideas?

Thanks,
Mark

"JLatham" wrote:

Second try --- grrrrr....
You may select multiple sheets in a workbook in 2 ways:
Select any sheet, hold down the [Ctrl] key while selecting any others, they
will become part of a group, and most changes made will be made to all
selected.
Select all sheets: select the first sheet in the workbook, bring the last
sheet in the workbook into view and hold down the [Shift] key and select it.
All sheets will now be selected as a group.

Conditional formatting does get applied to all selected sheets. To unselect
the group, just click on any non-selected sheet, or if all are selected,
select any individual sheet.

If you copy cells that have conditional formatting applied from one workbook
into another, the formatting will go with the copy.

"Mark" wrote:

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