FILL_CONDITIONAL_FORMATTING.osts

{"version":"0.3.0","body":"function main(workbook: ExcelScript.Workbook) {\n    // Your code here\n    let ws = workbook.getActiveWorksheet();\n    let ds = workbook.getWorksheet('RN-NCT LIST');\n\n\n\n    let patientName = ws.getRange('B7:B38');\n    let rnName = ws.getRange('E7:E38');\n    let rnNum = ws.getRange('F7:F38');\n    let nctName = ws.getRange('G7:G38');\n    let nctNum = ws.getRange('H7:H38');\n\n    let chargeName = ws.getRange('C4:C4');\n    let chargeNum = ws.getRange('F4:F4');\n\n\n    const cellValueConditionalFormatting = patientName.addConditionalFormat(ExcelScript.ConditionalFormatType.containsText).getTextComparison();\n\n    let rule: ExcelScript.ConditionalTextComparisonRule = {\n        text: '(S)',\n        operator: ExcelScript.ConditionalTextOperator.contains\n    };\n\n    cellValueConditionalFormatting.setRule(rule);\n    cellValueConditionalFormatting.getFormat().getFill().setColor('red');\n    cellValueConditionalFormatting.getFormat().getFont().setBold(true);\n\n    const nameAlertFormat = patientName.addConditionalFormat(ExcelScript.ConditionalFormatType.custom)\n\n    nameAlertFormat.getCustom().getRule().setFormulaLocal(\"=AND(L10>1,L10<8)\");\n\n    nameAlertFormat.getCustom().getFormat().getFill().setColor('00b0f0');\n\n    nameAlertFormat.getCustom().getFormat().getFont().setBold(true);\n\n    \n    patientName.getFormat().setShrinkToFit(true);\n    rnName.getFormat().setShrinkToFit(true);\n    nctName.getFormat().setShrinkToFit(true);\n\n}","description":"","noCodeMetadata":null,"parameterInfo":"{\"version\":1,\"originalParameterOrder\":[],\"parameterSchema\":{\"type\":\"object\",\"default\":{},\"x-ms-visibility\":\"internal\"},\"returnSchema\":{\"type\":\"object\",\"properties\":{}},\"signature\":{\"comment\":\"\",\"parameters\":[{\"name\":\"workbook\",\"comment\":\"\"}]}}","apiInfo":"{\"variant\":\"synchronous\",\"variantVersion\":2}"}