VBA - Find Cell Containing Variable - First Result Above Active Cell?

Need to find the first cell above the active cell containing any sort of variable (integer, string value, cell fill colour, named range, etc...).

For example, a column contains multiple integer values between 1 and 10. I would like the macro to "locate" a specified value, say 3. Ideally the macro will select the first cell matching this criteria, located above the active cell. Once located, the resulting cell will be added to a range to be copy-pasted to a new worksheet.

I am planning to use this code for various applications in a workbook I am creating. At present the code will be used to locate string values, and cell fill colours. It is also likely this will extend to other types of variables in the future.

I've found information relating to the find function, but nothing specifically to find the first result above the active cell.