Conditional formatting
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! |
Conditional formatting
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! |
Conditional formatting
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! |
Quote:
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 |
All times are GMT +1. The time now is 10:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com