Has to be easy?! - Highlight 'this year' in a list of years (over time)

[dougg]

I have a column from a list which just includes a series of descending
years, i.e.:

2008
2007
2006
2005
2004

What I want is for there to be conditional formatting such that only
the present year (i.e. 2005) is formatted differently (i.e. the box is
colored or some such thing).

How do you do this? Nothing I've tried works.

THanks, Doug

 

[Domenic]

Assuming that A1:A5 contains your data, try the following...

1) Select A1

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=A1=YEAR(TODAY())

4) Choose your formatting

5) Click Ok

Copy the format to your other cells using the 'Format Painter' or 'Copy

Paste Special > Formats'.

Hope this helps!

 

[JE McGimpsey]

I have a column from a list which just includes a series of descending
years, i.e.:

2008
2007
2006
2005
2004

What I want is for there to be conditional formatting such that only
the present year (i.e. 2005) is formatted differently (i.e. the box is
colored or some such thing).

How do you do this? Nothing I've tried works.

One way:

Select your column, say column A. Assuming A1 is active choose
Format/Conditional Formatting... Set the dropdown and textbox to read:

CF1: Formula Is =A1=YEAR(TODAY)
Format1: Patterns/<color>