Hi COB:

Can't you set the CFs in the general case for all the cells in the column
where there is data. This will check if cell is large or if it is small.


--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"COB" wrote:

How can various CF's in the same column stay referenced to their relative
cells when a sort is applied? eg I apply a specific CF to values in column
B that correspond to the cells in column A that read "Large". I have a
different CF in column B for cells in column A that read "Small". Then when
I sort any other column, the formatting gets scrambled.

--
thanks in advance!