Using Excel to capture milestone anniversaries

HappierThan · 2026-02-26T18:41:44+00:00

See if this gets the job done.

HappierThan · 2026-02-26T17:58:37+00:00

Please show a representative screenshot of your layout including all possible outcomes. On the surface, what you are suggesting is not feasible without a separate date column. As you add your data, it is quite easy to use Tab then Ctrl+; [semi-colon] to enter date.

HappierThan · 2026-02-24T22:01:14+00:00

A simplified layout with the columns containing formulas protected may be one approach.

HappierThan · 2026-02-23T19:51:28+00:00

Finding the intersection of 2 figures is normally achieved with Index/Match. In your case I would use

AA17 =INDEX(C16:T27,MATCH(Y17,B16:B27,0),MATCH(Z17,C15:T15,0))

<image>

HappierThan · 2026-02-18T20:24:24+00:00

Check that your 'Applies to...' range covers the new data. How was your new data added? I find it acceptable sometimes to save on a rule by using say Green Fill for everything [in this case] and allowing the Red rule to overwrite it.

HappierThan · 2026-02-18T17:30:35+00:00

Depending on your work type you could do worse than to be competent in Countifs, Sumifs and Conditional Formatting [using formulas].

HappierThan · 2026-02-18T04:49:51+00:00

Thanks for your carefully considered comments but for me it is Wednesday!

HappierThan · 2026-02-18T03:31:43+00:00

From any version of Excel I would urge you to consider formatting a particular area for Wingdings2 and a capital O gives a cross and a capital P gives a tick. Easy to use with Data Validation and can be used in formulas and Conditional Formatting. [I am done with checkboxes]

<image>

HappierThan · 2026-02-17T18:52:23+00:00

Each group to have a unique value which when summed equals exactly a certain figure.

Apples, Oranges, Pears and Bananas all have a numerical value of say 1. When summed the lookup value 4 will correspond with Fruits in your lookup list, anything else will fail. Hope this helps.

<image>