单元格背景颜色发生变化时，是否可以在excel中触发事件? [英] Is it possible to fire an event in excel when a cell background color changes?

问题描述

正如标题所说，我试图在单元格将背景色从红色更改为绿色时使某事发生，但是只有当用户更改单元格中的值时，才会触发工作表的更改事件，是否有解决方法来完成即时消息的尝试?还是不可能完成的任务?

as the title says, im trying to make something happen when a cell changes its background color, lets say, from red to green, but the change event of a worksheet only gets fired when a user changes a value in a cell, is there a workaround to acomplish what im trying to do? or is it an impossible task?

推荐答案

否.

(如:在VBA中，不可能，没有事件处理程序可用.重新设计表，使用格式作为结果而不是本身作为信息.)

(As in: it is not possible, there is no event handler available for that in VBA. Redesign your table, use formatting as a result and not as information in itself.)

这篇关于单元格背景颜色发生变化时，是否可以在excel中触发事件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！