Macro to conditionally format relative to position

[Ashe77]

Hi all

An odd request but I am using a program (against my preference) to create project plans which I then download to an excel file as an output and paste into another worksheet into a table. As it's downloading from a project style of indented child entries below parents, I'd like to conditionally format the table so that the child entries can be made into bold text. The issue is that it doesn't download with indents but actual spaces before the text. So ideally I need a macro that will instruct to bold entries with x amount of spaces in front (10, 15 and 20 spaces).

Can this be done?

Thanks in advance, Paul

 

[baitmaster]

I've seen waaaay stranger requests in this place..!

A simple example...

Sub Macro1()
Dim cl As Range
For Each cl In Columns(1).SpecialCells(xlCellTypeConstants)
    If Left(cl, 5) = "     " Then cl.EntireRow.Font.Bold = True
Next cl
End Sub

this looks at every cell in column 1 containing a constant (i.e. not a formula), and applies bold to the entire row if the first 5 text characters are spaces

 

[Ashe77]

Awesome thank you!