Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |