Conditional Formatting with Macro
Posted by Greg Collett on September 27, 2001 12:02 AM
I want to be able to set conditional formatting in a cell by using the Selection Change subroutine. I have seen the very useful version on this site which checks for changes in a column. I want to be able to check for changes in a particular cell.
I know that you can set conditional formating through the regular menu. However, users can copy and paste cells over the formatted cells thus loosing the settings.
I would very much appreciate it if someone could write the sample code. I will exchange this for another clever trick I have with buttons!