How do I highlight the first date of the following month

Barry, I afraid that yours marks the first day of the month only, not the first day of the month in the list.

# none will be marked with the sample in the original post.

Here is my method with one supplemental column of data by assuming the dates are in ascending order.

# as far as I know no formula can be used for conditional highlighting.

New column C, labeled as FirstDate hold the first date of the month on the list.

1. Add new column (C) if not exist

2. Set formula for C2 :

IFERROR(IF(EOMONTH(B1,0)=EOMONTH(B2,0),C1,B2),B2)

• EOMONTH() returns the last day of the month for the given date
• IFERROR() handles the first record where no valid date in the previous row.

3. Copy 'C2' then paste to C3 and beyond.

4. Select B2. Set conditional high as 'equal to' , [reference C2] (use the blue button in the input field to select C2)

5. Copy-Style 'B2' (opt-cmd-C), then Paste-Style (opt-cmd-V) to B3 and beyond.

Hi Z,

You should be able to do this with conditional highlighting.

As can be seen in the box below the table, the actual contents of each cell in column C is a Date and Time value (with the time automatically set to midnight at the beginning of the date that was entered).

The conditional highlighting rule, set to depend on text, ignores the contents, and attends to the displayed text. If that text ends with " 1", the rule is applied to add 'red fill' to the cell.

In your case, where the day is the first value in the displayed date, you could also use a Text rule:

text begins with 1/

Regards,

Barry

Hi To_Mi,

You are correct. I was reading too quickly, and missed the details.

Clever solution. Well done!

Regards,

Barry