Hi

I'm sorry but I'm not too much familiar with Excel. I have some listing in
column A

For example

in A1 I have:
D:\blabla\folder1\file1.xxx
in A2 I have:
D:\blabla\folder2\file2.xxx
in A3 I have:
D:\blabla\folder3\file3.xxx

I want the word between the 2nd and 3rd '\' to be in color red. So in A1
folder1 should be in red, in A2 folder2 in red etc

I could do it manually but there are like 3000 lines. It would take forever.
Is this simple to achieve with a script/macro/? ? I hope someone can help me.

Thanks in advance.
Christophe