Can't find VBA code to format a column based on text within a row

[LuciferUntamed]

So, I've got this report macro, currently works fine, but I'm looking at including a quality of life improvement to it.

What I'm after is something along the same lines as this
Format column with cell containing "Employee No" to custom format "000000"

I feel like this is a simple thing, but I'm relatively new to VBA and exploring how deep excel can go.

I can't upload any documents as an example as they all contain confidential information.

[Marc L]

So activate the Macro Recorder and operate manually : you will get your own code base …
… or just read the VBA help of the NumberFormat property.

Marc Hell

[LuciferUntamed]

The thing is, The column isn't always the same, and I'm new to VBA. Like, I only just started looking at it 2 weeks ago. The Macro that is currently in use, wasn't created by me. I'm just trying to add a little quality of life to it.
The Row is always the same, but the column isn't. The text I'm looking for is "Employee No". Then I need to format that column to a six digit number ie. "000316"
Sorry, I probably seem like the dumbest person.

[Marc L]

So post at least the code and a smart enough description of your data worksheet in order there is nothing to guess
or as it's easy to create & attach a sample workbook with dummy data but respecting the original layout …

[bakerman2]

Just a guess but this might get you started.

It looks for text on row 1, when foud that column gets formatted.

Please Login or Register  to view this content.

[LuciferUntamed]

Thank you,

I feel like that's close, although it didn't work.

I've attached a dummy sheet to what it looks like after the macro has run, before the macro has run, it's in row 1.

Row 6 contains an employee number at the length it should be.
In Cell H3 I've put an employee number as it should be with the 0's preceding

Should I be posting the Macro's code here too? only reason I haven't been is because it is lengthy.

[bakerman2]

Please Login or Register  to view this content.

[protonLeah]

If the column headers are always in row 3 then use a conditional formatting formula:

Please Login or Register  to view this content.