Conditional Color Change Not Working

[JohnGuts]

I read this thread, and I used the code from the vbaexpress.com hyperlink and I copied and pasted the exact code into my worksheet (Excel 2003). The only thing I changed were the conditions in the CASE statement (from "Tom", "Joe", "Paul") to "SL", "AL", "FL").

All other code remained the same but as I made changes to the data, no color changes took place.

I have a 6 month calendar with the dates (1-1-08 to 6-30-08) as the column headers and people names as the row headers. Each cell in the calendar is the result of a VLOOKUP function for the assignment each person has on a given date.

I am trying to have the fill color change depending on what the value of each cell is.

Not sure what I am doing wrong. Thanks for any help.

**MORE INFO**

I entered all the VLOOKUP funtion code in each cell, prior to using this VBA code to do the conditional formatting. It seems that the code works if I re-edit the formula in each cell then hit enter to save the formula in the cell. Is there an easier way to do this other than double clicking on each cell then hitting enter? I have a calendar that has 183 days across and 150 people down. That is 27,450 individual cells I would have to click on then hit enter.

Thanks for any help.