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

  • Thread starter Thread starter Stace Cameron
  • Start date Start date
S

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
 
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())
 
Back
Top