I am not sure if this can be done. I have an Excel sheet with various information, one of the columns is a follow up date. I have put some conditional formatting so that today's date appears in read in that column. However, the user would like to have all the rows that need to be followed up today appear on a separate sheet.
I was thinking that since I can do a formula such as =Sheet1!A3 is there no way to have an IF... THEN... formula that would do the =Sheet1!A3 IF C3 = today's date?
Thank you for your help