Find text, select column and change font

Hi,

Please help with the following:

I would like a macro to find the text "Number" in row A, then select the
column its located in, and if there are negative numbers change the font of
the negative number to bold and red.

I want to be able to find the text "Number" because its location is not fixed,
it could be K today and L tomorrow, which is why I'd like a macro.

Thanks in advance

=]

Thank you protonLeah, This is perfect =]

Thanks for your help!