I believe he was referring to Excel 2007 which is what I'm using but I don't
think I specified that.
Chad
****************

"David Biddulph" wrote:

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