Forum Discussion

Jimbobmcwalton's avatar
Jimbobmcwalton
Brass Contributor
Feb 22, 2019

Conditional Formatting Formulas

Does anyone know if its possible to have a column cell obtain information from an indexed table that has different format requirements?   IE    Line 1 Format needed in cell Y10 = 10% Line 2 Form...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 22, 2019

If you have some logic behind why Y10 shall formatted as per cent, Y11 as currency, etc, you may apply the formula which formalized that logic to conditional formatting rule.

  • Jimbobmcwalton's avatar
    Jimbobmcwalton
    Brass Contributor
    Feb 25, 2019

    Thanks Sergei,  That makes sense would you know the formula that I need for this?

     

    Currently in the cell I need the £ to show  I have 

     

    =INDEX(ProbMatrix[[#All],[Commission Rate]],MATCH(1,(V8=ProbMatrix[[#All],[Account]])*(W8=ProbMatrix[[#All],[Sales Person]])*(X8=ProbMatrix[[#All],[Over a Year]]),0))

    in the cell that shows the value I need 

     

    Below that in the cell I need to show the % 

     

    =INDEX(ProbMatrix[[#All],[Commission Rate]],MATCH(1,(V9=ProbMatrix[[#All],[Account]])*(W9=ProbMatrix[[#All],[Sales Person]])*(X9=ProbMatrix[[#All],[Over a Year]]),0))

     

    I have the formula in the table correctly, just need to apply it when it transfers over each time a line is added.

     

    Thanks for your help.

     

Resources