Conditional formatting


G

Guest

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
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top