How to Highlight Active Cell, Row and Column in Excel. Solved

Поділитися
Вставка
  • Опубліковано 28 бер 2024
  • Excel is very powerful application and we can do a lot to make our works interesting. Once such function is Conditional Formatting combined with VBA code.
    This video shows how we can highlight an active row, column, column and row together as well as Active cell only with very simple formula.
    1) HIGHLIGT A ROW ON A CONDITION
    =SEARCH("YES",$H5)greater than sign 0
    2) HIGHLIGHT ACTIVE ROW
    =ROW()=CELL("ROW")
    3) HIGHLIGHT ACTIVE COLUMN
    =COLUMN()=CELL("COL")
    4) HIGHLIGHT ACTIVE COLUMN AND ROW =OR(COLUMN()=CELL("COL"),ROW()=CELL("ROW"))
    5) HIGHLIGHT ACTIVE CELL =AND(COLUMN()=CELL("COL"),ROW()=CELL("ROW"))
    Introducing New Google Scholar PDF reader

КОМЕНТАРІ • 3

  • @Fsenpuhaokip1234
    @Fsenpuhaokip1234 Місяць тому +1

    Awesome to watch your channel Sir

    • @TechMe.79
      @TechMe.79  Місяць тому

      Keep watching all chapters to become an advanced user and save time 10x times

  • @sarinakhulakpam5810
    @sarinakhulakpam5810 2 місяці тому

    👍👍👍