Conditional Formatting - Column Differences

[MrExceller]

Hi there,

I am trying to create a conditional formatting in Excel 2003 in a single column to locate and highlight the values/formulae that is different than the others in that very column. For example: Column D summs all values in range A:C as below:

D1 = SUM(A1:C1)
D2 = (SUM(A2:C2)+10)
D3 = SUM(A3:C3)
D4 = (SUM(A4:C4)-5)
D5 = SUM(A5:C5)
D6 = SUM(A6:C6)

However, occasionally I might manually insert additional numbers like in cells D2 & D4 above.

What I want from conditional formatting is to locate such inconsistent cells like D2 and D4 and highlight them.

Tip: I can find such cells by pressing F5>>>Specials>>>Column Differences, but this is not handy and it's time-wasting

Appreciate any tip

Regards,

MrExceller

 

[earthworm]

Hi there,

I am trying to create a conditional formatting in Excel 2003 in a single column to locate and highlight the values/formulae that is different than the others in that very column. For example: Column D summs all values in range A:C as below:

D1 = SUM(A1:C1)
D2 = (SUM(A2:C2)+10)
D3 = SUM(A3:C3)
D4 = (SUM(A4:C4)-5)
D5 = SUM(A5:C5)
D6 = SUM(A6:C6)

However, occasionally I might manually insert additional numbers like in cells D2 & D4 above.

What I want from conditional formatting is to locate such inconsistent cells like D2 and D4 and highlight them.

Tip: I can find such cells by pressing F5>>>Specials>>>Column Differences, but this is not handy and it's time-wasting

Appreciate any tip

Regards,

MrExceller

go to condition formating and use the below formula

highlight all the area where you want the conditional formatting to be visible and in formula bar type =D1=SUM(A1:C1)

 

[MrExceller]

thank earthworm

it works just great

rgds