Conditional formatting: highlighting cells that more than the specified value

Home Documentation Writing Reading Pictures1 Pictures2 Formulas Date/Time SheetByName
Merging Grouping InsertRowCol NumFormats Formats Fonts Buffer1 Buffer2 Copying TopNFilter
Sorting StringFilter NumberFilter FilterByValues Protection Replacing RichString BeginWith
ColorScale OpRule AltRows

Conditional formatting: highlighting cells that more than the specified value

This example highlights cells whose values are greater than the specified value (90) with the light green background in the range C4:C11. It's possible to use any operator from CFormatOperator enum.

#include "libxl.h"

using namespace libxl;

int main()
{
    Book* book = xlCreateXMLBook();    
    
    Sheet* sheet = book->addSheet(L"my");

    sheet->writeStr(2, 1, L"Country");
    sheet->writeStr(2, 2, L"Road injures");
    sheet->writeStr(3, 1, L"USA");
    sheet->writeStr(4, 1, L"UK");
    sheet->writeStr(5, 1, L"Switzerland");
    sheet->writeStr(6, 1, L"Spain");
    sheet->writeStr(7, 1, L"Italy");
    sheet->writeStr(8, 1, L"London");
    sheet->writeStr(9, 1, L"Greece");
    sheet->writeStr(10, 1, L"Japan");

    sheet->writeNum(3, 2, 64);
    sheet->writeNum(4, 2, 94);
    sheet->writeNum(5, 2, 88);
    sheet->writeNum(6, 2, 93);
    sheet->writeNum(7, 2, 86);
    sheet->writeNum(8, 2, 75);
    sheet->writeNum(9, 2, 67);
    sheet->writeNum(10, 2, 91);    

    ConditionalFormat* cFormat = book->addConditionalFormat();
    cFormat->setFillPattern(FILLPATTERN_SOLID);
    cFormat->setPatternBackgroundColor(COLOR_LIGHTGREEN);

    ConditionalFormatting* cf = sheet->addConditionalFormatting();
    cf->addRange(3, 10, 2, 2);
    cf->addOpNumRule(CFOPERATOR_GREATERTHAN, cFormat, 90);
   
    book->save(L"out.xlsx");

    book->release();
    
    return 0;
}