Start by changing Show formatting rules for to let you see everything. That said, I can't think of any reason why conditional formatting would function differently across platforms. Note that my experience is entirely in the Windows-based version, so if the Mac version has any inexplicably different behaviors, it may just be Mac-version-strangeness.