Sorting With Conditional Formats

M

MichaelJ

I have a worksheet with approximately 50 rows of information. Each ro
contains some cells with Conditional Formats.

My problem is that when I sort the information, the conditional format
remain with the cell, rather than the resorted information.

Any hope out there for resorting and carrying the original cell
conditional formats
 
F

Frank Kabel

Hi
conditional formats are attached to a cell and not to the
value of this cell. So no chance that the format is
transfered while sorting.
There may be another solution if you provide us with the
conditional format formulas
 
M

MichaelJ

Thanks, even though its bad news.

Not sure how giving you the conditional formulas help because they var
by almost every line, but here is and example:

=AND(G3>4,G3<-4)

with the conditional format being a green cell shading.

Thanks for trying
 
Top