MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

change background color of cell by date

  Asked By: Cesar    Date: Mar 15    Category: MS Office    Views: 2492

I am using a spreadsheet to keep track of the chapters in a book I am
reading, 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?



1 Answer Found

Answer #1    Answered By: Hubba Akhtar     Answered On: Mar 15

You don't need any VBA for this. Excel has a feature called 'Conditional
formatting' which will do this for you. Excel Help covers the subject
pretty well.

Didn't find what you were looking for? Find more on change background color of cell by date Or get search suggestion and latest updates.