Set Excel Conditional Formatting Rules for Dog and Cat Appointment Reminders
Question details
Set conditional formatting rules that highlight pet appointments based on overdue days, upcoming appointments, and different reminder thresholds for dogs and cats.

- 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.
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.
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.
In Excel, select the cells in column D that contain the appointment day values, such as D2:D1000.
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.
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.
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.
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.

Convert the appointment range to an Excel Table for automatic rule expansion
Use this option when new pet appointments are added regularly and the formatting should extend to each new row automatically.
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. Open the appointment tracker: Open the workbook in WPS Spreadsheet and select the appointment-status cells in column D.
- 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. 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. 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. 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.

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.




