Rol
10-09-2008, 05:35 PM
This project uses the very helpful VBA code from "conditional formatting (more than three)" by "DRJ" (thankyou!). To find the VBA code just search for "Conditional Formatting (More Than Three)" on this website
With this code I can format any cell. Eg, by typing the letters "gp" and then pressing enter, the background colour of the cell changes to yellow. However, at the moment, I'm unable to undo any changes.
I would like to integrate this undo command I've found from a webpage that can be found by using Google to search for "undoing_a_vba_subroutine". The website is called The Spreadsheet Page
The problem I have is that I don't know how to integrate the undo command into the conditional formatting VBA code. Can anyone help?
I've attached two files that show the conditional formatting and the undo command working OK separately. How can I get them to work together?
With this code I can format any cell. Eg, by typing the letters "gp" and then pressing enter, the background colour of the cell changes to yellow. However, at the moment, I'm unable to undo any changes.
I would like to integrate this undo command I've found from a webpage that can be found by using Google to search for "undoing_a_vba_subroutine". The website is called The Spreadsheet Page
The problem I have is that I don't know how to integrate the undo command into the conditional formatting VBA code. Can anyone help?
I've attached two files that show the conditional formatting and the undo command working OK separately. How can I get them to work together?