Just in case people try as I did - The above code only works in Excel
97-2003.
I brought it home and tried it out on Excel 2007 and it did not work.

On 7¤ë8¤é, ¤È«e11:19, pallaver wrote:
SOLUTION!!!

I figured out how to get VBA to give me whichconditionalformat for
the cell (1, 2, or 3) was used! Since everything is done via VBA, I
know that 1/2 are NG situations, and 3 is OK, thus I can color my
desired OK/NG cell according to which CF for the cell was used.