How to enter dates and then have excel color in those dates

jgrant78

New Member
Joined
Mar 18, 2011
Messages
10
Hello everyone,

This is what I am trying to accomplish. I want to be able to enter a date or range of dates ie...3/17/2011 or 3/1/2011-3/17/2011 in a cell and then have those dates change color on a calendar that is on the same sheet or another tab or tabs. Hope I explained myself well enough and thanks for any help in advance becuase I am not very good with this type of stuff.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

jgrant78

New Member
Joined
Mar 18, 2011
Messages
10
This is my last attempt for help on this subject :). Nobody knows how to do this?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,708
Messages
5,524,428
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top