Late thought - I suppose, in Excel 2007, you could set up the conditional
formatting in a single sheet as you need it to be and then just copy that
sheet as many times as needed. Of course, this solution only works well at
the very outset of your project, not after you have varying data in existing
sheets that also need the same formatting. In that case, my previous
suggestion of using Copy with Paste Special / Formats may be the only way
out, if it works.

"Mark" wrote:

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