# Conditional formating

#### tarek

##### New Member
I appreciate any help with the issue am having. here is the what I am trying to do:
Column A
35155976
35156348
35156348
35160550
35160550
35160550
35160550
35161189
35161189
35161201
35161201

I would like to highlight the rows (Entire row) for similar values in Column A. so since A2=A3 then i would like both rows (the entire row and not only the cell) the same apply for 35160550 (A4,A5,A6 and A7)... and so on!

I've tried using the following formula: =A2=A1 and picked a color but the porblem is this formula leave the first cell of the matching series unfilled, example:
35160550
35160550
35160550
35160550
the very first "35160550" is not colored but the rest are and i need them all to be colored, plus am not able to get my conditinal formating to color the enire row.

Thank you

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Try

=COUNTIF(\$A\$1:\$A\$100,\$A1)>1

And to make it cover the whole row, just slect all relevant columns at the time you go into conditional formatting.

Hi,

If I have understood you correctly, does this help?

Excel Workbook
ABCDEF
1NumbersData1Data2*Check*
235155976CatRed*FALSE*
335156348DogYellow*TRUE*
435156348PigGreen*TRUE*
535160550CowBlue*TRUE*
635160550RatPink*TRUE*
735160550CatOrange*TRUE*
835160550DogBlack*TRUE*
935161189PigWhite*TRUE*
1035161189CowPurple*TRUE*
1135161201RatBrown*TRUE*
1235161201CatGrey*TRUE*
13******
Sheet1

You can use the formula in D2 for your Conditional Formatting, you will need to change the cell references to suit your layout.

Highlight from the top left cell of your data to the bottom right cell.

I hope this helps.

Ak

Last edited:
Thank you so much Jonmo1 and Akashwani you guys are awesome!!! it worked

Glad to help, thanks for the feedback.

Hi tarek,

I'm pleased it worked for you and you are right, Jonmo1 is awesome.
Thanks for the feedback.

Ak

Hi tarek,

I'm pleased it worked for you and you are right, Jonmo1 is awesome.
Thanks for the feedback.

Ak

Thanks Ak, to be fair you gave the same answer

Hi Jonmo1

I know, but you are AWESOME, I'm not even A!!!
I've a long way to go to get to the E!!

Ak

Replies
14
Views
646
Replies
6
Views
75
Replies
5
Views
422
Replies
6
Views
272
Replies
10
Views
215

1,207,423
Messages
6,078,443
Members
446,338
Latest member
AliB

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back