Conditional Formatting
I have created a calendar using the DAY function to just return the DAY of
another cell in 01/05/07 format. I want to be able to enter a date in 01/05/07 format in a cell outside of the calendar and have all the days prior highlighted. I tried using the Condiotional Formatting in the Format menu, but I can't seem to figure it out. Am I on the right track, or is there a better way? Please help, Joel |
Conditional Formatting
If the calendar is in D1 thru J4 and the ref cell is A1, then select D1 and
set the conditional formatting to: Formula is: =D1<$A$1 then copy this format to all the cells D1 thru J4 -- Gary''s Student - gsnu200750 "Jase4now" wrote: I have created a calendar using the DAY function to just return the DAY of another cell in 01/05/07 format. I want to be able to enter a date in 01/05/07 format in a cell outside of the calendar and have all the days prior highlighted. I tried using the Condiotional Formatting in the Format menu, but I can't seem to figure it out. Am I on the right track, or is there a better way? Please help, Joel |
All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com