resaltar numeros de una hoja a otra

[dragonfire33]

como puedo resaltar cualquier numero de la columna al a la hoja 2

 

[KOKOSEK]

Debes usar VBA.

Sub GetValuesFromYellowCells()
Dim srcWs, destWs As Worksheet
Dim lastR As Integer
Dim srcRng, cell As Range
Set srcWs = Sheets("Hoja1")
Set destWs = Sheets("Hoja2")
Set srcRng = srcWs.Range("AZ1:BW40")    ' range of source
For Each cell In srcRng
    lastR = destWs.Cells(Rows.Count, "AL").End(xlUp).Row + 1       ' column name into column with result on Hoja2
    If cell.Interior.Color = 65535 Then destWs.Cells(lastR, "AL").Value = cell.Value       ' as above column with results
Next cell
End Sub

 

[dragonfire33]

alguna otra idea ya que no me funciona

 

[KOKOSEK]

What do you mean by 'does not working'? Error? If yes in what line?
Check in vba editor code for you yellow, I've used 65535 as standard yellow from ribbon. Yours can be a bit different.
You can type in immediate window:

debug.print Sheets("Hoja1").Range("BA9").Interior.color

and press Enter.
then put this here:

 If cell.Interior.Color = XXXXX

 

[RaulARodriguez]

Yo he copiado el codigo proveido por @KOKOSEK y si funciona, por favor provee un poco de informacion, porque no te funciona?