Precise and reliable gene delivery remains technically challenging. Here we report a splicing-based approach for controlling gene expression whereby separate translational reading frames are coupled to the inclusion or exclusion of cell-specific alternative exons. Candidate exons are identified by analyzing thousands of publicly available RNA-Seq datasets, and filtered by cell specificity, conservation, and local intron length. This method, which we denote splicing-linked expression design (SLED), can be combined in a Boolean manner with existing techniques such as minipromoters and viral capsids. SLED vectors can leverage the strong expression of constitutive promoters, without sacrificing precision, by decoupling the tradeoff between promoter strength and selectivity. We generated SLED vectors to selectively target all neurons, photoreceptors, or excitatory neurons, and demonstrated that specificity was retained in vivo when delivered using AAV vectors. We further demonstrated the utility of SLED by creating what would otherwise be unobtainable research tools, specifically a GluA2 flip/flop reporter and a dual excitatory/inhibitory neuronal calcium indicator. Finally, we show that SLED vectors can rescue photoreceptor degeneration in Prph2rds/rds mice, and selectively induce apoptosis in SF3B1 mutant cancer cells with an oncolytic vector. The flexibility of SLED technology enables new avenues for basic and translational research.