Forum Discussion
Highlight Cell with "If" Fucntion
=IF((ROUNDDOWN((I20/J6); 0)*I6)>0;MATCH(H6;B1:B51;0);"NO")
Ttying to;
1. / i20 to j6
2. Rounddown it
3. then * with i6
4. "If" it is lager than zero (>0)
5. "Match" H6 in column B1 betwee...
Hi,
I didn't check the formula, but if it is correct you may add the rule into conditional formatting which with =ISNUMBER(<your formula>) checks the cells to highlight and apply it to your range. But it very depends on how your data is structured to use correctly combination of relative and absolute references in your rule formula.