Can I change the background color depending on the cell content?

[Arana]

I am making an index of a large number of files and folders. My objective is to be able to modify the background color of all those cells that correspond to a folder, that is, that the path does not end in the file name and its extension.

I have tried to use the conditional rules that Excel offers to achieve it but it is impossible for me.

All help is welcome.

This is a small example:

 

[JamesCanale]

Put this into the conditional formatting. It looks for a "." in the text after the last "/" in the path.

=NOT(ISNUMBER(SEARCH(".",DROP(TEXTSPLIT(A1,,"/"),ROWS(TEXTSPLIT(A1,,"/"))-1))))

 

[etaf]

can you search for a .
or count
=COUNTIF(A1,"*.*")

But conditional formatting wont highlight text separately
you will need VBA for that

Book2
	A
1	/folde/path/fiule.ext
2	/folde/path/
3	/folde/path/fiule.ext
4	/folde/path/
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A4	Expression	=COUNTIF(A1,"*.*")	text	YES