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

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
 
T

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

T. Valko

P.S.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Date List 1
outlook 2007 to-do list groups dates incorrectly 0
Can you lock a drop-down cell so that it sorts with the row? 1
can I create a drop down list to pick a date ? 3
extend the range of cells for a drop down list 8
Date Selector 2
Use first day of month formula in a drop down list 3
Hide Columns Based On Date Value 1

Top