Cell Format within ABCD

Hi

I have some worksheet to do about the ranking of the schedule and number as reference, the steps is start from X,Y,Z. now i have done format for the X value (picture attach) for the ranking within A,B,C,D which one have highest number and should be the place at top position (number followed 1,2,3,4). Example if X value between A and D have same number, should be will be use Y value (picture attach) for reference because X value is same. Example if Y value is same between A and D and should be use Z value (picture attach) for reference because Y value are same. Now if number in X,Y, Z (picture attach) is changing to another number and of course all position will be change also, so how i want to create the format for this situation if all number will changing to another? Have any one can help me?

Thanks in Advance,

Regards,

Uncle Rich...