Apply Conditional Formatting on Row

Hi. Need a solution for applying conditional formatting on whole row if order no. is same in above cell.

further, Is it possible to get unique colors each time when condition matched? (Optional)

My attachment shows more specific what i needed.

My data is in Table format. I am open to get any formula which can do the same function (VBA codes is not applicable)

Thanks in advance

Naghman

Hi Naghman,
Try with this.
First remove all formatting you have already on your file. In Cell B3 create new "Formatting rule". Select "Use formula to determine which cell to format". Insert the below formula as a formatting rule:

=OR(AND($B3=$B2,$B2<>0),AND($B3=$B4,$B4<>0))

And add the range which you need to be formatted.

This will format only the double entrees. Unfortunately, I don't know how to make different color for the formatting.

Igor

418472d1441972747-apply-conditional-formatting-on-row-apply-cf.xlsx

Hi Igor. It works perfect. Thanks a lot for your help. This fulfills my requirement almost 70% but if get option to get different colors by same formatting so it will be superb.

Hi Naghman,
You'll need to create 2 conditional formatting each with one of the below formulas

=AND(OR(AND($B3=$B2,$B2<>0),AND($B3=$B4,$B4<>0),COUNTIFS($B$3:$B$150000,B3)>=2),NOT(ISEVEN(SUMPRODUCT(($B$3:B3<>"")/COUNTIF($B$3:B3,$B$3:B3&"")))))

=AND(OR(AND($B3=$B2,$B2<>0),AND($B3=$B4,$B4<>0),COUNTIFS($B$3:$B$150000,B3)>=2),ISEVEN(SUMPRODUCT(($B$3:B3<>"")/COUNTIF($B3:B$3,$B$3:B3&""))))


Igor

test.xlsb