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!

Hi,

Try formatting cell value is between 01/01/2009 and 31/12/2010.

"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!

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!

make sure that dates exist in non text format and use conditonal formatting

assuming date exist in A1.
=or(year(A1)=2009,year(A1)=2010).

if they are in text format, convert into non text format by =text(A1,"dd/mm/yyyy") and use the above formulae.

all the best