I have a table that has three columns, each getting its data from a COUNTIF function. The three columns are Totals, Positive and Negative. I also have conditional formatting that formats the row depending on the totals.
I am trying to sort these based on the totals or the conditional formatting (Fill colour) but each time I try the sort leaves 3 or 4 cells above the marker (i.e. there should be 4 blue rows on the top and 6 white rows beneath after sorting, but it seems to ignore some of the cells, with 3-4 white cells on top of the blue cells and more white cells below. I thought it was a pretty simple thing and have tried sorting it by both the cell colour and the totals amount seperately to no avail.
Please help!!!
Bookmarks