且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Excel条件格式可以在条件中使用UDF吗?

更新时间:2023-11-14 20:01:04

是的,可以。

您的问题很简单,就是那里有引号。您需要从下拉列表中选择公式是,然后您的公式应该是

Your problem is simply that you've got quotes in there. You need to choose "Formula Is" from the drop-down, and then your formula should be

=isManualPrice(R22C12)

...没有引号。

(我更习惯于A1表示法,而不是R1C1表示法,但我认为这样做也一样。)

(I'm more used to A1 notation rather than R1C1 notation but I assume that'll work just as well).