Conditional Formatting problem
 

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

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)


"Cumbo" wrote in message
...
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?????

One way:

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

In article ,
"Cumbo" wrote:

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