02-25-2024 10:31 AM
I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm"). Can anyone provide the conditional formatting text that would replace the actual % variance with text?
Solved! Go to Solution.
02-26-2024 02:18 PM
This is our |!Percentage_Cell!| parameter:
Scale=0, ExcelUseScale = True,
If (CellAmount >= 10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else If (CellAmount <= -10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else
NumberFormat = [#,###,0.0%], ExcelNumberFormat = [#,###,0.0%]
End If
For anything greater than +/-1000% (10), we replace the value with 'NA'. Apply to your row/column cell format as applicable.
02-26-2024 02:18 PM
This is our |!Percentage_Cell!| parameter:
Scale=0, ExcelUseScale = True,
If (CellAmount >= 10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else If (CellAmount <= -10) Then
ExcelNumberFormat = ["NA";"NA";"NA"], NumberFormat = ["NA";"NA";"NA"]
Else
NumberFormat = [#,###,0.0%], ExcelNumberFormat = [#,###,0.0%]
End If
For anything greater than +/-1000% (10), we replace the value with 'NA'. Apply to your row/column cell format as applicable.
02-26-2024 02:40 PM
Thank you so much! That worked perfectly.