Conditional Formatting problem

[Guest]

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?????

 

[Bob Phillips]

select the cells, and then use CF with Formula Is and a formula of

=RIGHT(A1,1)="."

format as required.

This assumes the data is column A, starting in A1

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[JE McGimpsey]

One way:

CF: Formula is =RIGHT(A1)="."