Hi David

That was in XL2007, which the OP did mention in his first post.
You are quite right, in XL2003 it is the square above row 1 and left of
column A
In XL2003 you need to type Ctrl +A twice to select the sheet.

--
Regards

Roger Govier


"David Biddulph" wrote in message
...
Which version of Excel is that, Roger?
On Excel 2003 the only thing that I could see which might be described
as a "small cell with a triangle, above row numbers" is the name box,
and that doesn't select the whole sheet.
On my version, to select the whole sheet one needs to click in the
square in the top left-hand corner (above the row 1 and to the left of
the column A labels), or alternatively Control A will select the whole
sheet.
--
David Biddulph

"Roger Govier" wrote in message
...
Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill