Excel Forum



Excel Magic Trick 296: Conditional Format Intersection Row & Column


See how to add Conditional Formatting to a row, a column and the intersection of the two with three different colors. See three TRUE FALSE formulas for highlighting the whole row, the whole column and the intersection of the two. Mixed Cell References are the key the three TRUE FASLE formulas





Got a Question? Ask it Here in the Forum.