FreakyGirl
Member
hello
im having a couple of problems with my worksheet.
problem 1.
i have a conditional format that will highlight top 3 numbers in any given row. if there is a 0 in the row it goes wacky & highlights many other cells in the same row.
i have attached my sheet. please look at row 26 to see the above. now look at row 49. if another 0 is added, the same thing will happen.
my code:
problem 2:
same workbook, same conditional, please refer to rows 22 & 46. there are 4 cells highlighted. every time the G column increases it will highlight another cell. the goal is to only have the top 3 in any row. it wont highlight until there are at least 3 numbers but then it doesnt stop.
any help of course would be appreciated.
ty in advance
FreakyGirl
im having a couple of problems with my worksheet.
problem 1.
i have a conditional format that will highlight top 3 numbers in any given row. if there is a 0 in the row it goes wacky & highlights many other cells in the same row.
i have attached my sheet. please look at row 26 to see the above. now look at row 49. if another 0 is added, the same thing will happen.
my code:
Code:
=AND(SUMPRODUCT(--ISNUMBER($I9:$AD9))>=3,RANK(I9,$I9:$AD9)+SUMPRODUCT((I9=$I9:$AD9)*(I$8>$I$8:$AD$8))<6)
problem 2:
same workbook, same conditional, please refer to rows 22 & 46. there are 4 cells highlighted. every time the G column increases it will highlight another cell. the goal is to only have the top 3 in any row. it wont highlight until there are at least 3 numbers but then it doesnt stop.
any help of course would be appreciated.
ty in advance
FreakyGirl