Highlighting complete row with conditional formatting

[tcollins]

I am using Excel 2007. I need to find duplicates based on three different columns. I took all three columns and combined them and then I used the conditional formatting that is built in to find duplicates in that column and highlight them. Here is where I run into the problem. I need it to highlight the whole row instead of just the cell. Any ideas how to do this?

Tracy

 

[PCL]

What is the formula used for the Conditional Format, why you cannot used it for other cells in the same row?

 

[tcollins]

I'm not sure what the formula is. Here is what I did:

I have columns from A through O.
In column P I created this formula to combine three columns:
=B2&" "&C2&" "&E2

This formula gave me the contents of those three cells in one cell. I then copied that formula all the way down. This works fine.

Then in Excel 2007 there is an option for conditional formatting>highlight cell rules>Duplicate Values it then brings up a box that tells you what color it will make those cells. However, it only highlights the cells and not the entire row. I then have to manually highlight the full row.

Hope this makes sense.

Tracy

 

[The Todal]

Set the conditional format formula for all cells in the row to be the same as the cell you are using to determine the key condition. The only difference is that each cell in the row will reference your key cell instead of its own cell. For example, I have a sheet where I want to highlight the entire row if it is the row for the current month. I have a date in column C. My conditional format formula for ALL cells in the row is as follows:

=AND(MONTH(TODAY())=MONTH($C68),YEAR(TODAY())=YEAR($C68))

In other words, the conditional formatting for cell D68 looks at the data in cell C68 to decide whether or not to display the specified formatting.

 

[PCL]

It looks like you want to highLight the complete row when there is the value equal to =B2&" "&C2&" "&E2 (here for row2)
If yes select a cell (D2 for example), select conditional format with formula and enter next formula = =$B2 & " " & $C2 & " " & $E2 and select the format you want.(care about the $)
Then copy this cell (D2) and make a Paste Special format for all cells.
You don't need your extra column P