As you will see in the sample i have found a way by adding a formula into the actual cell that returns a addtional symbol to the cells if the added values are above the critriea . This meaning i can conditional format with a strring search.
I dont like how lengthy the formula is and am open to suggesttions
|