Need Help with AND function (cell colour or GANT chart)

[Cdn_chico]

I am trying to produce a formula that will do the following in m
worksheet:

I have a row of months (Jan to Dec), I also have two columns wit
months, the first column shows me when I am supposed to Start my wor
task, the second column shows me when I am supposed to Finish my wor
task. I want the cells under the row of months to change colour so tha
it shows me a bar of colour (ie. RED) under the period of months i
which I am supposed to do the work. Some sort of scheduler or Gan
chart done in excel. So far I have tried using the AND formula, and i
does the proper logic, except that it shows TRUE under the months I a
working, and FALSE under the months I am not working, I want to replac
the TRUE and FALSE with a different text or a different cell colou
other than white. Here is the formula I got so far.

It would look like the picture (did that manually)
Thanks.

Ed

=AND(MONTH(H37)+YEAR(H37)>=MONTH($D$5)+YEAR($D$5),(MONTH(H37)+YEAR(H37)<=MONTH($E$5)+YEAR($E$5))

+-------------------------------------------------------------------
|Filename: Excel_Chart.gif
|Download: http://www.excelforum.com/attachment.php?postid=2679
+-------------------------------------------------------------------

 

[dcronje]

Have you tried using the formula in conditional formatting?

Under format>conditional format..

 

[Dee]

In the conditional formatting, if you don't want to see
the word "TRUE" or "FALSE", then make your font color the
same as your fill color and it will look like a
highlighted blank cell.

Dee
Reston, VA