Conditional Formatting

B

Brokovich

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.
 
R

robert111

get rid of the IF

example

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

excel will code that for you
 
Top