Excel Magic Trick 424: Conditional Formatting For Dynamic Range

Описание к видео Excel Magic Trick 424: Conditional Formatting For Dynamic Range

Download Files:
https://people.highline.edu/mgirvin/Y...

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.

Комментарии

Информация по комментариям в разработке