Conditional formating

[tarek]

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.

Please help!

Thank you

 

[Jonmo1]

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.

 

[Akashwani]

Hi,

If I have understood you correctly, does this help?

Excel Workbook
	A	B	C	D	E	F
1	Numbers	Data1	Data2	*	Check	*
2	35155976	Cat	Red	*	FALSE	*
3	35156348	Dog	Yellow	*	TRUE	*
4	35156348	Pig	Green	*	TRUE	*
5	35160550	Cow	Blue	*	TRUE	*
6	35160550	Rat	Pink	*	TRUE	*
7	35160550	Cat	Orange	*	TRUE	*
8	35160550	Dog	Black	*	TRUE	*
9	35161189	Pig	White	*	TRUE	*
10	35161189	Cow	Purple	*	TRUE	*
11	35161201	Rat	Brown	*	TRUE	*
12	35161201	Cat	Grey	*	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.
The set your CF.

I hope this helps.

Ak

 

[tarek]

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

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[Akashwani]

Hi tarek,

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

Ak

 

[Jonmo1]

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

 

[Akashwani]

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