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.
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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks