conditional formatting - multiple conditions in gantt chart

[debbw]

Greetings! I am trying to add a condition to a formula that will change the bar color based on referencing a cell value of "F" in Column c ($C7). This column allows the project manager a quick view to know who is "field" employee vs. "office" employee. I'm using Office 365.
The basic formula to select dates is:
=AND(task_end>=I$5,task_start<J$5)

Where & how do I incorporate "$c7="F"

Basically, I'm looking for: "IF column c ="F", then format the date range (task_end>=I$5,task_start<J$5) to my desired color.

I haven't been able to find this specific scenarion anywhere. Any help is GREATLY appreciated.
THANK YOU!

 

[pjmorris]

try this: =AND(task_end>=I$5,task_start<J$5, $c5-"F")
(I assume you mean row 5 not 7?)

 

[debbw]

try this: =AND(task_end>=I$5,task_start<J$5, $c5-"F")
(I assume you mean row 5 not 7?)

Thank you for trying, Peter. Unfortunately, that didn't work (I did the same thing). Here's a screenshot of that formula's results. The left side "assigned to" is column C (task_assigned to). The goal is to have the "green" bar for anything assigned to "F"

 

[Fluff]

How about

=AND(task_end>=I$5,task_start<J$5,$C7="F")

 

[debbw]

How about

=AND(task_end>=I$5,task_start<J$5,$C7="F")

Thank you, but I'm still getting mixed colors on the row, not specific to "F"
-Deb

 

[Fluff]

What is the applies to range for that condition?

 

[debbw]

What is the applies to range for that condition?

=$I$8:$BL$34
Capturing the full date range of the project
Previous range started at "J" & just noticed that was incorrect.

 

[Fluff]

In that case you need to use $C8="F"

 

[debbw]

In that case you need to use $C8="F"

Still nothing... (& let me say how MUCH I appreciate your help!)

 

[Fluff]

Can you post a sample of your data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.