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.