palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have the following lookup table .,..
If I use the following formula in one of the cells listed in that table, for example if I place the formulae in cell N10, it returns a "Y" as it should ....
=IF(COUNTIF($CH$6:$DF$31,ADDRESS(ROW(),COLUMN(),4))>0,"Y","")
I've checked the formula in all of the cells mentioned in the list and they've all returned the appropriate result ... a "Y"
I've check the formula in cells that are not in the list, and they've returned a blank result, as expected.
So, in short, I know the formula works.
However when I try to use it in conditional formatting, where, I want the cells to return as filled with the colour black, nothing happens.
Can anyone see where I have gone wrong ?
If I use the following formula in one of the cells listed in that table, for example if I place the formulae in cell N10, it returns a "Y" as it should ....
=IF(COUNTIF($CH$6:$DF$31,ADDRESS(ROW(),COLUMN(),4))>0,"Y","")
I've checked the formula in all of the cells mentioned in the list and they've all returned the appropriate result ... a "Y"
I've check the formula in cells that are not in the list, and they've returned a blank result, as expected.
So, in short, I know the formula works.
However when I try to use it in conditional formatting, where, I want the cells to return as filled with the colour black, nothing happens.
Can anyone see where I have gone wrong ?