With your data in Column A;

--Select Column A or the range. A1 mentioned in this example is the first
cell of the range.

=COUNTIF(A$1:A1,A1)=1

If this post helps click Yes
---------------
Jacob Skaria


"momotaro" wrote:

Hi,
Is there a way to set up a conditional formatting between texts? Here is
what Id like to be:

Text
Text
Text - This will be color

Credit Card - this will be color
Credit Card

Discover Card - this will be color
Discover Car

Any suggestions would be appreciated.