Conditional Formatting, based on multiple values

[russelldt]

Hello,

I am using the following of format task durations in a simple Gantt chart:

=AND(task_end>=K$5,task_start<L$5). This condition gives me a colour to format the row between the task start and task end dates. (row 5 being the days)

The additional criteria I want to add is that the colour of the task bar must be dependent on the value in column C, meaning that if C=Tom, the task bar colour is (say) red, and if it is Harry, the colour is Green, and so on.

Any help would be appreciated

 

[Fluff]

You would need to create a separate rule for each colour.

 

[russelldt]

You would need to create a separate rule for each colour.

Thanks Fluff, I have the 2 rules, but I am struggling with the formula to determine which Colour to apply.
I have tried the following conditions, and I don't get the correct result.


=IF(AND(task_end>=K$5,task_start<L$5),$C$7="Tom")
=IF(AND(task_end>=K$5,task_start<L$5),$C$7="Harry")

 

[Fluff]

They should be like

=AND(task_end>=K$5,task_start<L$5,$C$7="Tom")

 

[russelldt]

They should be like

=AND(task_end>=K$5,task_start<L$5,$C$7="Tom")

thanks Fluff

 

[Fluff]

Glad to help & thanks for the feedback.

 

[ShambolicColleague]

They should be like

=AND(task_end>=K$5,task_start<L$5,$C$7="Tom")

What does the 7 denote? (i have same issue as original post).

Many thanks for your contribution

 

[Fluff]

What do you mean?

 

[ShambolicColleague]

What do you mean?

Why is it $C$7="Tom" and not the whole column?

 

[Fluff]

Because that is what the OP was using.