Conditional formatting
Hi,
Let me give you an actual example. I have a column E with dates of births. In the other column, I have a formula that calculates age of every employee basing on his date of birth. Formula is as follows: =DATEDIF(E4,TODAY(),"Y")&" years, " & DATEDIF(E4,TODAY(),"ym")&" months, " & DATEDIF(E4,TODAY(),"md")&" days" E4 value is 27-May-1972, therefore result will display '33 years, 9 months, 14 days' Now, when I mark the whole column, I use conditional formatting to display age differently. Greater than 35 should color the cell yellow, less or equal to 35 should fill blue. But it doesn't, it only fills cells with yellow. How can I make it recognize age as presented above? Thanks |
Conditional formatting
Hi,
For you column containing your age set you conditional formatting to use 'Formula Is' and refer to your DOB column (E) - something like '=DATEDIF(E1,TODAY(),"Y")35'. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "umba-sr" wrote: Hi, Let me give you an actual example. I have a column E with dates of births. In the other column, I have a formula that calculates age of every employee basing on his date of birth. Formula is as follows: =DATEDIF(E4,TODAY(),"Y")&" years, " & DATEDIF(E4,TODAY(),"ym")&" months, " & DATEDIF(E4,TODAY(),"md")&" days" E4 value is 27-May-1972, therefore result will display '33 years, 9 months, 14 days' Now, when I mark the whole column, I use conditional formatting to display age differently. Greater than 35 should color the cell yellow, less or equal to 35 should fill blue. But it doesn't, it only fills cells with yellow. How can I make it recognize age as presented above? Thanks |
All times are GMT +1. The time now is 12:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com