Sorting drop down list value that create data validation by last used

Hi, I made a list of cell values f1:f10 with conditional formatting in range a1:a100
I want this list to be sorted by the last used value
It is possible?

You cannot create a list of values using conditional formatting. Provide a workbook so that members can work out what you mean.

In the drop-down list created
Any of the most recently used values
Upper than other
Example If i select yellow in drop down list after close list and again click on list the yellow is upper than red in the list

I asked you to attach a workbook.

And that last post makes ZERO sense without one!

Example If i select yellow in drop down list after close list and click on list the yellow is upper than red in the list

This makes no sense, either, and I asked you to attach a workbook, NOT a screenshot.

You should by now know what our requirements are:

1. Provide a desensitised sample workbook.
2. In the workbook, mock up expected results.
3. Add detailed and clear annotations within the workbook to signpost the data for your helpers.

What does "upper than other" mean? I'll have a look and see if I can work it out.

sort value in drop down list by most used

By most used where? You have not mocked up what you want. This workbook is of practically no use at all!

Come on, please - show us what you want.

@AliGW
Thank you very much for your follow up
I mean if one more color is chosen
be sorted and displayed above the rest of the colors in the drop-down list that opens
For example, yellow is the 7th color in the drop-down list
And since it has been selected 6 times, I want it to come first in the drop-down list
Or the orange color is the 4th in the drop-down list, and because it is selected 5 times, it comes second in the drop-down list
And ....

In B1:

=COUNTIF(H3:H1500,A1:A15)

In C1:

=SORTBY(A1:A15,B1#,-1)

DV losy source: =$C$1#

Apply to all cells with the same rule.

@AliGW
Excellent, thank you very much

can change name of topic by "Sorting drop down list value that create by data validation as last used"

Yes, but it's a bit late for that, isn't it???