Hope someone can help. I need a macro which will change the colour of a whole row in my data range, depending on the number of days overdue a task is. I want the macro to run when I open the file so I can see at a glance those tasks I need to chase up. I have a column with an IF function that works out the number of days overdue. I know the macro should be straightforward but I don't know where to start.