I have an Excel sheet where column G contains required dates and column J contains scheduled dates. If the scheduled date > required date (row by row) I want to conditionally format the scheduled date in red to show it's late. Doing it by absolute ref works but I don't know how to do the whole sheet.
Any help available?
Any help available?