Hi
Basically I have two columns expected start date and actual start date for a number of jobs. I want to create conditional format where if the actual start is greater than the expected date it higlights the date red and if it is below or equal to it turns green. I managed to do it for one cell, but the conditions don't seem to want to drag to the corresponding cells and keeps on refeering to the original date for the first job rather than the date for that job. How can I create this format for the other cells, without conditional formatting each individual cell (there are a lot of jobs)?
Thanks
Bookmarks