search box. hightlights entire row when found

[shakeyy]

hi guys,

what is the formula if i type a word in the cell, it highlights the row if it exist.

Thank you

[jeffreybrown]

That's not a formula, it's conditional formatting.

or https://www.contextures.com/xlCondFormat03.html

[mehmetcik]

You are probably talking about Conditional formatting.

Click on the top left hand corner of excel to select all cells.

Click on the home tab and then conditional format and then manage rules.

Select New Rule and then "use formula.................."

Paste this formula into the formula bar =$A1=$A$1

Click on the Format Tab, then fill and select a colour.

This will highlight every row where column A contains the same number as Cell A1.

To stop Row 1 being highlighted.

Select Row 1

Click on the home tab and then conditional format and then manage rules.

Select Clear Rules, and then Selected cells.