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:
But this does not work. Can anyone suggest anything?
get rid of the IF
A1 + A2 > vlookup(C1,table,2)
excel will code that for you
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1