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?




Line 1 Format needed in cell Y10 = 10%

Line 2 Format needed £4 Y11 = £4 


I need to do this, or I could get the data to go into Column Z10 instead but I need to add the 2 adjacent cells together so would need to exclude either Y10 or Z10 as appropiate.


Any ideas?




2 Replies

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.

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.


Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies