leighmetcalfe
New Member
- Joined
- Oct 27, 2012
- Messages
- 46
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.
=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.