Conditional Formatting

Hi there!

I am trying to use IF and VLOOKUP functions in conditional formatting and am struggling. I have a list of employees and their start dates in one place on the workbook, and a list of the employees again in another table on the workbook. I want to format the names in the table so that they are bold if the start date is less than a year old from today's date. I have tried:

=IF((VLOOKUP(B4,B75:C138,2,FALSE)<(TODAY()-365),1,0)

But this does not work. Can anyone suggest anything?

Thanks!

B.

get rid of the IF

example

A1 + A2 > vlookup(C1,table,2)

excel will code that for you