Forum Discussion

BAHAEDDİN ÖZDEMİR's avatar
BAHAEDDİN ÖZDEMİR
Copper Contributor
Dec 04, 2017

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 between B52

6. "If" no say "no"

Question: I want my formula to "HIGHLIGHT" the cell which matches. Don't know how to do this. Formula is working, saying "no" or giving me the column number. Can you help me pls?

Excel Desktop
Formulas & Functions

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Dec 14, 2017

    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.

     

     

Resources