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 FormatConditional Formatting
3. For Condition1Select '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 ButtonPattern and select your color (say Red)
5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.

--
Jacob (MVP - Excel)


"puiuluipui" wrote:

Hi, i need a formula to highlight call containing 2010 and 2009.
I have cells that containing dates in "dd.mm.yyyy" format.

Can this be done?
Thanks!