Highlight cells based on dates

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 cells with a date before the 27th September 2019 in column A (Date).
   

   

   
   
   
3. Click Format and then Conditional formatting. A toolbar will open to the right.
   Note there are multiple options to apply rules to dates, a special case Date occurs is explained in step 5.
   

   

   
   
   
   
4. Create a rule by choosing the condition and the style if required.
   For this example: In "When" select value "date is before", and in the picker field pick "09/27/2019" to select the condition. Select the background color (light purple) and select the font color(dark purple). Click "Add Rule".
   

   

5. Add another Rule (If required)
   If multiple rules are required, you can stack rules together. 
   In this example we are highlighting dates that occur this week in dark brown text, with light yellow background. You may notice that the existing Conditional Formatting rule is displayed.
   Note: "Date Occurs" can be use to identify moving date functions, like Today, yesterday, last week, last month etc. This ensures that the same dates are not highlighted every day. 
   

   

   
   
   
   
6. Exit after you have applied all the required rules. Your Excellentable should show the rules in the Conditional formatting now.
   

   

   
   
   

See Also:

Conditional Formatting in Excellentable

View/Edit existing conditional formatting