Excel Tips - Automatically Highlight Active Row and Column | Based on Cell Selection

Описание к видео Excel Tips - Automatically Highlight Active Row and Column | Based on Cell Selection

In this video we cover how to highlight the entire active row in Excel based on your cell selection.

Formula used in conditional formatting: =OR(CELL("ROW")=ROW(),CELL("COL")=COLUMN())

VBA code used: Target.Calculate

Комментарии

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