adding to the drop down for "Format cells that contain a date occuring"

[Stace Cameron]

In conditional Formatting,Highlight Cells Rules,A Date Occurring.

Is it possible to expand the drop down list to include "this year"? The
list currently consists of:

Yesterday
Today
Tomorrow
In the last 7 days
Last Week
This Week
Next Week
Last Month
This Month
Next Month

 

[T. Valko]

You'd have to use:

Conditional Formatting>Manage rules>New rule>Use a formula to determine
which cells to format

Then use a formula like this:

=YEAR(A1)=YEAR(NOW())

 

[T. Valko]

P.S.

Seems like a glaring omission on MS' part to have not included a YEAR
condition.