I have a spreadsheet with conditional formatting. I would like to

B

Barbara KEyt

I have a spread sheet with conditioanl formatting adding color to specific
data. I would like to sort by this fomat so all this data is together. Is
there a way to sort by formats?
 
V

vezerid

Strictly speaking, no. One thing you can do is to use an auxiliary
column, with a (nested) IF, employing the same conditions that you use
for CF. The "highest" condition could return a 3, the next one a 2 and
so on. You can then sort according to this column.

HTH
Kostis Vezerides
 
Top