Excel Forum

Excel Magic Trick 424: Conditional Formatting For Dynamic Range

See how to conditionally format a range of cells by selecting items from a drop down list. The dynamic range will be formatted using a TRUE FALSE formula that uses AND, MATCH and COLUMNS functions.

Got a Question? Ask it Here in the Forum.