I want to know if I can conditionally format cells in a column of data which
end with a full stop - i.e if this is a column of data I want to be able to
highlight...

blue. - highlight
Yellow
red. - highlight
black
brown
green. - highlight

Any ideas?????