Find a cell and highlight

[jdgamet]

Hello All, I need to create a macro that takes three parameters (tab name, Row# and Col#) i have them in three different columns. Then based on those three parameters find the correct cell and highlights it in yellow...Anyone has an idea how to simply do this?...

Thank you very much,

 

[Fluff]

Hi & welcome to MrExcel.
maybe something like

Sub Hilitecell()
   Dim Cl As Range
   For Each Cl In Range("A2", Range("A" & Rows.Count).End(xlUp))
      Sheets(Cl.Value).Cells(Cl.Offset(, 1).Value, Cl.Offset(, 2).Value).Interior.Color = vbYellow
   Next Cl
End Sub

 

[jdgamet]

Thank you Fluff...how do you find a value of one cell in one tab in another tab?....

 

[My Aswer Is This]

Thank you Fluff...how do you find a value of one cell in one tab in another tab?....

What do you mean by find?
You want to display the value in a Message box or do something else when you find the value

And you said:
fi

nd a value of one cell in one tab in another tab

in what cell in what tabs
​

 

[jdgamet]

I mean in one tab i have 5 columns: one column has a list of school names...the other 4 columns have dates: fcst, actual, preliminary, etc. The scound tab has 7 columns: one column has school names, the other columns also have dates. i need to find each school name in first tab in the second tab...when i find a match that row will be used to compare the dates on both tabs....

 

[My Aswer Is This]

When wanting help here we always need specific details to sort out a script for you.
See here you sad:

I mean in one tab i have 5 columns​

We need to know the name of the sheet and we to know what columns.
Is it column 1 to 5?

See here you sad:
one column has a list of school names...the other 4 columns have dates​

Which one has the school names?

Then you said:

i need to find each school name in first tab in the second tab​

What is the name of the second sheet and in what column do we look

And you then said:

when i find a match that row will be used to compare the dates on both tabs....​

Compare the dates and do what.