Hot answers tagged conditional-formatting
Are you willing to have the key values replicated onto the other sheets? If so, set SheetY!Q3 to =SheetX!D3, and then have SheetY!D3 conditionally formatted using the value in SheetY!Q3 (but otherwise the same conditional formatting rules as SheetX!D3). You can hide Column Q when you get it working.
Only top voted, non community-wiki answers of a minimum length are eligible