Need conditioanl formation forumla to color two diff value

[sharadmaxwell]

I have follingn data in one colume
i need only 1 colour when value change
please see the attached file to understand my requirement

this is my data
1.JPG

and i want like this
2.JPG

[sktneer]

Insert a helper column, say column B in this case and place the following formula in B2 and copy it down. You can hide the helper column after placing the formula.

Please Login or Register  to view this content.

Then select whole column A and make a new rule for conditional formatting using the formula given below and set the format as per your choice.

Please Login or Register  to view this content.

ConditionalFormatting.jpg

[sharadmaxwell]

need to do without helper coulumn

[sktneer]

Okay, select the range A2:A17 and make a new rule for conditional formatting using the formula given below and set the format as per your choice.

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Formula for CF for cell A3

Please Login or Register  to view this content.

Copf Format ot other cells.

[kvsrinivasamurthy]

This formula also works

=ISODD(SUMPRODUCT(1/(COUNTIF($A$3:$A3,$A$3:$A3))))