Conditional formatting

[momotaro]

Hi,
Is there a way to set up a conditional formatting between texts? Here is
what I’d 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.

 

[Jacob Skaria]

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

 

[pogiman]

Do you mean a conditional format will be made if the contents are the same as
the criteria (Text, Credit Card, Discover Card, etc.) or randomly done?