Conditional formatting
 

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.

Conditional formatting
 

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.

Conditional formatting
 

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?

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.