hi All,
need a little help please.
in column A I have several different names, in column B I have a list of dates.
what I need to do is change the colour of the cell in column D using conditional formatting when the name (lets say David) appears next to a date that greater than 180 days.
I can get the cell to change based on the name alone however I cant get the date side to change so putting them together is defiantly looking like its going to fail.
any help would be appreciated
steve
need a little help please.
in column A I have several different names, in column B I have a list of dates.
what I need to do is change the colour of the cell in column D using conditional formatting when the name (lets say David) appears next to a date that greater than 180 days.
I can get the cell to change based on the name alone however I cant get the date side to change so putting them together is defiantly looking like its going to fail.
any help would be appreciated
steve