Conditional Formatting

[leighmetcalfe]

I have the below formula for a worksheet conditional formatting.

=IF(B6="",FALSE,SUMPRODUCT((B6>=INDIRECT("Table1[Start]"))*(B6<=INDIRECT("Table1[End]"))))

im looking to change it to only work if with in table1[Hol] = H.

 

[kvsrinivasamurthy]

May be this

=IF(table1[Hol] = "H,IF(B6="",FALSE,SUMPRODUCT((B6>=INDIRECT("Table1[Start]"))*(B6<=INDIRECT("Table1[End]")))),FALSE)

 

[leighmetcalfe]

no it didn't work.

 

[kvsrinivasamurthy]

Slight mistake was there. I corrected it. Please check once again.

=IF(table1[Hol] = "H”,IF(B6="",FALSE,SUMPRODUCT((B6>=INDIRECT("Table1[Start]"))*(B6<=INDIRECT("Table1[End]")))),FALSE)

 

[leighmetcalfe]

when tying to add the formula, is shows an error so wont let me click apply.

 

[kvsrinivasamurthy]

Try this
In 6th row

=IF(table1[[#This Row],[Hol]] = "H”,IF(B6="",FALSE,SUMPRODUCT((B6>=INDIRECT("Table1[Start]"))*(B6<=INDIRECT("Table1[End]")))),FALSE)