Highlighting an appropriate line

[stepan1987]

Hi guys,
I have a sheet with raw data and another one - with formulas that reflect MINs, MAXs and different VLOOKUPs from the first sheet.

I want some tool that would enable me doing the following:

On sheet 2 I have a formula that reflects the MIN / MAX from column G on sheet 1. I want the row containing this MAX on sheet 1 somehow highlighted. For example, i click on the formula / or input cell address somewhere and automatically get the sheet 1 open with the needed row highlighted.

Hope there is a way

Thanks in advance!

 

[rs2k]

Here is some code that I use to find/highlight rows by using an input box, you may be able to adapt it to suit your needs

Sub find_highlight()
Range("A4:IV3140").Select
Selection.Interior.ColorIndex = xlNone
Range("A4").Select
w = InputBox("What to find?")
Cells.Find(What:=(w), After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
With Selection.EntireRow.Interior
.ColorIndex = 6
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End Sub

HTH
Colin

 

[stepan1987]

Thanks, too bad I m a complete noob in macros scripts.. Any formulas anybody?)

 

[vasim]

Just press CTRL = [ on the formula on second sheet.