0
Please forgive me since I don't know where to start with this problem. I have an Excel sheet with multiple columns. Two of the columns are dates in the format of "MM/DD/YYYY HH:MM:SS", column A and column B. I want to highlight when column A is more than 2 hrs ahead of column B.
I click on A2 and tell it to highlight the A2 cell when cell value[dropdown option] is greater than[dropdown option] =B2 Then I click on the paintbrush to copy formatting to all column A cells and that works; A* cells that are > B* cells are highlighted. A* cells that aren't > B* cells don't get highlighted.
However, I tried to say =B2+120 (for 120 minutes) or =B2+7200 (for 7200 sec) and it doesn't work. Are there any tips on getting this to work? Am I supposed to convert to epoch and then do the comparison + 2 hrs? I don't want to have to convert to epoch and then do the comparison b/c I have several sheets to do this on. If I can just click on conditional formatting and do what I did in the screenshot and add + 2 hrs in minutes or seconds, it will make it easier/faster to check each sheet.
Thanks in advance for your help.