I am using a spreadsheet to keep track of the chapters in a book I amreading, and alert when I fall behind.For ease of use, the dates are on multiple rows.What code can I use to change color in the cell with TODAY'S date?
You don't need any VBA for this. Excel has a feature called 'Conditionalformatting' which will do this for you. Excel Help covers the subjectpretty well.