I got it working!!!

Thanks again. I greatly appreciate it!


wrote:
Hello Bob,

This works except for one thing. I only want the date range designated
in columns E and F to be grayed over in the "green gantt chart area"
but not in the rest of the row. That way we still see our Gantt chart
but get to see the grayed areas as complete. The other cells out side
that date range designated by E and F should be the white/no color
background.

Make sense?

Thanks again for all your help.


Bob Phillips wrote:
I have updated your file to show how to do it. It is a zip file, as it was
too big to upload it vanilla. Get it at :http://cjoint.com/?kupXBMVtGM

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
Hello,

I posted a question last night but see that I have one piece to finish
my spreadsheet.

Here it is...

I have a Gantt Chart that I am developing in excel. Basically I have
conditional formatting that compares the date range of a particular
task to the actual date and thus fills in small excel squares showing
visually how things are progressing in the timeline. It shows in
little green squares When the task starts and when it is supposed to
end.

Here is a screenshot of what it looks like.

http://download.shireinteractive.com/images

So basically as you can see on row 31 I have the text grayed out
because 'X" is in the field B31. I would like to apply that same
grayed out effect to the green date range on the right in row31.

Currently that date range code looks like this.

=IF(AND(V$3=$E13,V$3<=$F13),1,"")

There is then a conditional formatting applied to that cell telling it
that if it equals "1" to make that cell green.

Right now anything that is not in the date range is white, Anything
that is in the date range is green. I want to add one more component,
anything that is in the date range and has an "x" in the B column in
that row, I want it to turn that green date range to Gray.

Is this possible?

If this doesn't make sense please let me know and I will try to explain
in a different manner.

I have also posted the excel spreadsheet in that link above for your
convenience.

As always thanks for your time.