conditional format not working

[palaeontology]

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 ?

 

[Fluff]

For CF you would just use

=COUNTIF($CH$6:$DF$31,ADDRESS(ROW(),COLUMN(),4))>0

 

[palaeontology]

That worked brilliantly, thankyou so much.

Very kind regards,

Chris

 

[Fluff]

You're welcome & thanks for the feedback.