Highlighting rows if different values different values

[wraithu]

Hi,

How can I mark or highlight rows if there are changes in values within that row?

Please note that attached is only an example to show what I need, I have noumerous rows and columns to work on. Values can range up to 1.000.000.

[Pete_UK]

First of all, select cells A2:F7 and remove the fill colour from them. While those cells are still selected, click on Conditional formatting | New rule | Use a formula... from the bottom of the list, and put this formula in the dialogue box:

=AVERAGE($B2:$F2)<>MAX($B2:$F2)

Click on the Format button, then the Fill tab and choose your colour. Then OK your way out.

Hope this helps.

Pete

[Pete_UK]

Actually, thinking about it further, perhaps this would be a more robust formula:

=AND(AVERAGE($B2:$F2)<>MAX($B2:$F2),COUNT($B2:$F2)>1)

to ensure that you had at least 2 numbers on each row.

Hope this helps.

Pete

[wraithu]

Actually, thinking about it further, perhaps this would be a more robust formula:

=AND(AVERAGE($B2:$F2)<>MAX($B2:$F2),COUNT($B2:$F2)>1)

to ensure that you had at least 2 numbers on each row.

Hope this helps.

Pete

Hi Pete,

This is rad. Thank you very much!