Sorting by Format

bshred

New Member
Joined
Nov 16, 2002
Messages
24
Hi there

I have a column of cells, some of which are coloured a particular shade of yellow. How do I sort by or select only those cells, so that I can paste them elsewhere?

Cheers
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,639
Members
412,334
Latest member
ExcelForLifeDontHate
Top