Quote:
Originally Posted by 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!
|
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