View Single Post
  #2   Report Post  
EdG2015 EdG2015 is offline
Junior Member
 
Posts: 2
Cool

Hi,

I've managed to resolve by using a nested if function with \*Charformat switch. If anyone else struggles like me I've put the format below. Note use Ctrl+F9 to get the curly brackets ({}]:

{ IF { =(a1/a2)*100 } = 100 { =(a1/a2)*100 \# “#%” \*Charformat } { IF { =(a1/a2)*100 } 80 { =(a1/a2)*100 \# “#%” \Charformat } { =(a1/a2)*100 \# “#%” \*Charformat } } }

Where the underlined section has dark green text and light green background through the font and paragraph formatting, the bold section dark red text and light red background and the bold section dark orange text and yellow background. This replicates the red/amber/green conditional formatting of excel where green is =100%, amber is 80-99.9999% and red is 80%, and the sum is cell A1/A2 (could be replaced with R1C1/R2C1). This can be modified accordingly to allow for multiple variables (up to 20 I believe) and with differing formats and inputs.

Hope this helps someone else who has struggled like I have!