Conditional formatting error

[beedistinct]

This formula works when I use it in the cell. Why is it not working as a conditional formatting rule ? It complains when I intoduce the VLOOKUP.

=AND(IF($C$4="Day",$F7<=I$2,$F7<=I$2+6),$G7>=I$2,VLOOKUP($H7,ResourceTable,2,FALSE)="Programmer")

 

[Norie]

What's the 'complaint'?

 

[martindwilson]

IF($C$4="Day",$F7<=I$2,$F7<=I$2+6)
what is this supposed to be doing?
should if be OR?
or($C$4="Day",$F7<=I$2,$F7<=I$2+6)

 

[beedistinct]

What's the 'complaint'?

A dialog box pops-up saying "The formula you typed contains an error".

Am trying to create a Gantt chart and vary the color by the resource type like programmer. The Team table (called ResourceTable) has 2 columns the first one has name and second column has the resource type.

This is what I'm looking up.

 

[beedistinct]

Thanks, Everyone! The issue is resolved.

The REsourceTAble was a table and not a Name. I guess excel does not accept table names in Conditional formatting. When I used a Name (named range), it worked!

 

[Norie]

Never tried using a table reference in conditional formatting.

Aren't they usually enclosed in []?

Perhaps if you use [ResourceTable] it will work.