1. Select the cell/Range (say A1:A10). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
'if you have the dates in excel date format then try
=OR(YEAR(A1)=2009,YEAR(A1)=2010)
'if you have the dates as text then try
=OR(--RIGHT(A1,4)=2009,--RIGHT(A1,4)=2010)
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.
