ExcelBanter - Sorting by color Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting by color Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/136347-sorting-color-excel-2007-a.html)

CathyZ

Sorting by color Excel 2007

How can I sort cells based on the color in Excel 2007.

the formula "=colorindex(A2)" is coming back as error message "#Name?"

tom

Sorting by color Excel 2007

CathyZ,
Excel 2007 has many unique sorting functions... While in the "home sheet"
tab choose the Sort and Filtering funcationality in-which you can select
custom sort by color.
Hope that helps,
Tom
"CathyZ" wrote:

How can I sort cells based on the color in Excel 2007.

the formula "=colorindex(A2)" is coming back as error message "#Name?"

All times are GMT +1. The time now is 01:31 AM.