It's pretty complicated for explanation in this forum setting. I think you will be better served by asking in Microsoft's Office:Mac forums here:
There are a lot of Mac-using Excel gurus there. Be sure to tell them your verison of Excel when you post--it could make a difference.
BTW- is this your way of saying you have no idea
Fair question! The answer is "not exaclty."
I used Excel a lot when I was a working engineer but am retired now, so I'd have to almost see your sheet and work through it to refresh my conditional formatting recollections. I used CF a lot then but haven't had too many reasons to do so since. Almost all MS Word now.
So yes, I have Excel experience, but it is rusty and I figured you'd get faster help in the MS forums. I have a boilerplate answer for when I don't know squat:
Can you post back if the other forum has what you need?