Formatting Issues

Set Excel Conditional Formatting Rules for Dog and Cat Appointment Reminders

Bushra ParveenBushra Parveen Nov 12, 2026 868 views

Question details

Set conditional formatting rules that highlight pet appointments based on overdue days, upcoming appointments, and different reminder thresholds for dogs and cats.

Excel Conditional Formatting for Dog and Cat Appointment Reminders
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet tracks pet type in column A and appointment day status in column D. The user wants reminders to apply across the full data range and continue for new records.
Observed behavior
Appointments should be gray after 90 days, blue when upcoming, and highlighted at 21 days for dogs or 35 days for cats before reaching 90 days.
Before you start

Confirm that column A contains consistent pet types such as Dog and Cat, and that column D contains numeric day values. Select the first data row and the full column or table range before creating the rules.

Solution 1Recommended

Create prioritized conditional formatting rules for the appointment status column

Use this method to apply different colors to overdue, upcoming, dog, and cat appointment reminders in column D.

Create the rules using the first data row number in the formula, such as row 2. Apply each rule to the same appointment-status range, for example $D$2:$D$1000.

1
Select the appointment status cells

In Excel, select the cells in column D that contain the appointment day values, such as D2:D1000.

2
Add the 90-day overdue rule

Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =$D2>=90, choose a gray fill, and set the Applies to range to your column D data range.

3
Add the upcoming appointment rule

Choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =$D2<0, choose a blue fill, and apply it to the same column D range.

4
Add the dog reminder rule

Create another formula rule from Home > Conditional Formatting > New Rule. Enter =AND($A2="Dog",$D2>=21,$D2<90), choose the reminder format, and apply it to the column D range.

5
Add the cat reminder rule and verify rule order

Create a final formula rule with =AND($A2="Cat",$D2>=35,$D2<90). Open Home > Conditional Formatting > Manage Rules and arrange the rules in this order: gray, blue, dog, then cat.

Create prioritized conditional formatting rules for the appointment status column
Reminder thresholds are separated: The dog and cat rules exclude values of 90 or more, so the gray overdue rule remains the active format after 90 days.
WPS Spreadsheet formatting tools

Create Pet Appointment Reminder Rules in WPS Spreadsheet

WPS Spreadsheet lets you create formula-based conditional formatting for appointment tracking, including separate dog and cat thresholds, upcoming dates, and long-overdue visits. Convert the list to a table-style range or apply rules to a full column so new appointment records remain easy to review.

  1. 1. Open the appointment tracker: Open the workbook in WPS Spreadsheet and select the appointment-status cells in column D.
  2. 2. Create the overdue rule: Choose Home > Conditional Formatting > New Rule, select a formula-based rule, enter =$D2>=90, and choose a gray format.
  3. 3. Create upcoming and pet-specific rules: Add formula rules for =$D2<0, =AND($A2="Dog",$D2>=21,$D2<90), and =AND($A2="Cat",$D2>=35,$D2<90).
  4. 4. Set the rule range and order: Open Conditional Formatting > Manage Rules, set each rule to the same column D range, and place the gray, blue, dog, and cat rules in that order.
  5. 5. Extend the tracker for new appointments: Apply the rules to a larger column D range or use a formatted data table so new appointment rows inherit the reminder formatting.
Create formula-based conditional formatting for dog, cat, upcoming, and overdue appointment statuses.Apply reminder rules across an entire WPS Spreadsheet column.Open and edit Microsoft Excel .xlsx and .xls appointment trackers.Use a familiar spreadsheet interface for a smooth transition from Excel.
QA img-9

Frequently Asked Questions

Why do the dog and cat reminder formulas use $A2 and $D2?

The dollar signs lock the formula to columns A and D while allowing the row number to change for each appointment record. This lets one conditional formatting rule evaluate every row in the selected range.

How do I make an appointment blue when it is upcoming?

Select the appointment day cells in column D, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter =$D2<0 and choose a blue fill.

What happens when a dog appointment reaches 90 days?

The dog formula includes $D2<90, so it no longer applies at 90 days. The gray rule =$D2>=90 then formats the appointment as long overdue.

Can I use these rules for new rows added later?

Yes. Apply the rules to a larger range in column D, such as $D$2:$D$1000, or convert the source range to an Excel Table through Insert > Table so formatting expands with new rows.

Why is the cat reminder rule not formatting some rows?

Check that column A contains exactly Cat and that column D contains a numeric value from 35 through 89. Extra spaces, different labels, text-formatted numbers, or values outside that range prevent the formula from matching.