blindsighted
New Member
- Joined
- Jul 14, 2012
- Messages
- 4
Greetings,
I am using Excel 2007. I need to conditionally format a worksheet. Specifically a column of dates. The sheet is to show the Student's Names and Dates of Birth. I need to make all the dates between January 1 and September 30 (regardless of year) to be light green cells and students with dates of birth October 1 through December 31 to be a different color. The date format I have in that column is mm/dd/y yyy. I believe I would need to choose the option in Conditional Formatting that allows me to put in a formula. However, I do not know the correct formula/expression to enter. Can one of you gurus tell me the correct formula for my task?
I am using Excel 2007. I need to conditionally format a worksheet. Specifically a column of dates. The sheet is to show the Student's Names and Dates of Birth. I need to make all the dates between January 1 and September 30 (regardless of year) to be light green cells and students with dates of birth October 1 through December 31 to be a different color. The date format I have in that column is mm/dd/y yyy. I believe I would need to choose the option in Conditional Formatting that allows me to put in a formula. However, I do not know the correct formula/expression to enter. Can one of you gurus tell me the correct formula for my task?