Auto Highlight active row and column by condition formatting #excel #exceltutorial #msoffice

In this video, we will learn how to automatically highlight the active row and column using conditional formatting. We will utilize the following formula to achieve this:

```
=OR(CELL("col") = COLUMN(), CELL("row") = ROW())
```

This formula will highlight both the active row and column based on the current cell position.

#excel #advancedexcel #exceltutorial #excelshortcuts #msoffice #exceltips #conditioning #condition #formatting

Видео Auto Highlight active row and column by condition formatting #excel #exceltutorial #msoffice канала Industrial MS Office