开发者

How can I detect the results of Conditional Formating using VBA?

开发者 https://www.devze.com 2023-01-03 19:23 出处:网络
I have a开发者_开发问答n excel file that has conditional formating set up to put a check or an x in a cell. How can I create an if statement that will detect which is in there without using the origin

I have a开发者_开发问答n excel file that has conditional formating set up to put a check or an x in a cell. How can I create an if statement that will detect which is in there without using the original conditioning formulas?


You can use this homemade function to check if condition is filled: http://www.cpearson.com/excel/CFColors.htm

0

精彩评论

暂无评论...
验证码 换一张
取 消