Let me explain the problem in further detail. This is a workbook with 3 worksheets. The first was is called "Plan," and this is where user input the project the have or will have (approx 400 rows). The second sheet is called "Calendar," and this I want to be an automated sheet---in other words, when users enter new projects in the "Plan" sheet, the first 3 columns on the "Calendar" sheet populate (i used an indirect formula). The 12 following columns are headed with the months of the year. Right now I have this formula {=IF(AND(Calendar!$C3>=Sheet3!C$2, Calendar!$C3<=Sheet3!C$32), "X", "")}. Sheet 3 has every day of the year in computer format (i.e., January 1, 2004=37988)
I would like a formula or something that would allow for when a date falls within a certain month, then that cell would be highlighted blue (or some other color)
Thank
----- Ken Wright wrote: ----
Name the cells on the other sheet and then use the names in the CF formula. :-
--
Regard
Ken....................... Microsoft MVP - Exce
Sys Spec - Win XP Pro / XL 97/00/02/0
---------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-
---------------------------------------------------------------------------
sandy said:
I am trying to find a formula that will allow me to highlight a cell the colo
of my choice when it is true. I have tried conditional formatting, but becaus
my formula links from other worksheets, it won't allow me. Here's my curren
formula
