Breadcrumbs

Highlight cells based on a formula


You can highlight entire row or columns based on formulas


  1.  Open a confluence page and create a new Excellentable or edit an existing Excellentable.

  2. Select the cells you want to apply format rules to.
    In this example we want to highlight all rows where the total is greater than 450.
    Capture 2019-10-02 at 19.59.49.png

  3. Click Format and then Conditional formatting. A toolbar will open to the right.

    Capture 2019-10-02 at 19.59.52.png


  4. Create a rule by choosing the condition and the style if required.
    For this example: In "When" select value "this formula is true", and in the formula field "=$H2>409" to select the condition. Select the background color (light green) and select the font color(dark green). Click "Add Rule"

    To highlight all rows based on a column H, reference the formula with the Column locked as $H2
    In case you wanted to highlight all columns based on the value in 2nd row, you could have used A$2


    Capture 2019-10-02 at 19.59.54.png



  5. Add another Rule (If required) If multiple rules are required, you can stack rules together. 


  6. Exit after you have applied all the required rules. Your Excellentable should show the rules in the Conditional formatting now.
    Capture 2019-10-02 at 19.59.56.png

See Also:

Conditional Formatting in Excellentable

View/Edit existing conditional formatting