Steve,

Am having trouble following your formula. But I get #NUM as a result
whether I enter it as an array or normal formula.

Suggest you take it a piece at a time and test it.
Put each piece in a cell as a regular formula.

The #REF usually means that the reference doesn't exist.

Make sure that you follow the standard formats for the formulas.

Small() = Small(Array,k)
I am having trouble with this part of your formula.

--
sb
"Steved" wrote in message
...
Hello from Steved

Thanks for your quick reponse
Below is the formula that returns #REF! if there is no
Data I tried Conditional Formating but I having no luck

{=INDEX(B$1:$C$217,SMALL(IF(B$1:$B$217=$D$17,ROW
($B$1:$B$217)-ROW($B$1)+1,ROW($B$217)+1), $E$20),2)}


-----Original Message-----
Steve,

Look at Conditional Formatting with Cell Value ="#REF!"

--
sb
"Steved" wrote in
message
...
Hello from Steved

I would like to know is it possible in VBA to find #REF!
in any cell in the worksheet and color the text white as
to give the appearence the cell is blank.

Thankyou.


.