General Discussion - Sorting by colour in Excel

[etaf]

was not sure where to put a general discussion , excel forum seems the only logical place

I have just seen a tutorial on how to sort by cell fill colour,

5 Ways to Sort by Color in Microsoft Excel | How To Excel

www.howtoexcel.org

i thought this was only possible by VBA , and seen that as the response on quite a few threads , that it cannot be done

in fact often question asked is - does the sheet have conditional formatting , and then use those rules

but looking at the tutorials and google searches - this appears to have been available for some time 2007

i have clearly missed something

I just wondered what version was this introduced , tried google and not got a decent reply - no point using AI - as that has been wrong 80% of the time whenever i used chatgpt !

 

[etaf]

bump

 

[Peter_SSs]

as not sure where to put a general discussion

In the "General Discussion & Other Applications forum.
(I have moved it there for you)

 

[RoryA]

As best I recall it was introduced in 2007, at the same time as filtering by colour.