Conditional formatting

  • Thread starter Thread starter momotaro
  • Start date Start date
M

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.
 
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
 
Back
Top