EXCEL: How can I use a custom function created in VB as formula for conditional formatting?

0

I created a VB script to validate a personal document from my country (just like the Social Security number in USA).

It is BOOLEAN, receives the number as param and returns only TRUE or FALSE if it's valid. Now I need to use this function as formula for conditional formatting. There's any way to do this?

Carlos Messala Oliveira

Posted 2015-12-09T17:42:20.850

Reputation: 51

Yes you can. What have you tried and where are you running into issues? – Kyle – 2015-12-09T18:51:46.750

You can read my script here.

– Carlos Messala Oliveira – 2015-12-10T19:56:01.370

... and a screenshot of the error here. The literally translation for the error message is: "It cannot use this kind of references for a formula Conditional Formatting."

– Carlos Messala Oliveira – 2015-12-10T20:08:46.163

No answers