Conditional formatting

[puiuluipui]

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!

 

[ck13]

Hi,

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

 

[Jacob Skaria]

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.