Conditional Formatting based off Cell Input Change

[eguirocker3]

Instructions are on attachment. Need to conditional format cells so that if someone makes change, it will highlight.

[sktneer]

Try this...

Right click on Sheet1 Tab --> View Code --> Paste the code given below in the code window --> Close VBA editor --> Save your workbook as Excel Macro-Enabled Workbook.

Please Login or Register  to view this content.

Change the value of any cell in col. A and see if the cell is highlighted.
Is this what you are trying to achieve?

[eguirocker3]

I have multiple excel files that all look the same (same look and amount of columns, just more rows due to more promos). What do I need to change within the macro toadjust to the attached file? Previous attachment was a dummy example. Please see this attached file. The cells in Column J and W on both September and October is
what needs targeted. So if someone changes a value in the cells in column J and W, then it needs to highlight so I know they changed it.

FYI one cell is red for a reason due to a conditional formatting rule I have in place so ignore that.

[sktneer]

Try this.....

Please Login or Register  to view this content.

[eguirocker3]

This is awesome! Thank you soo much!

[eguirocker3]

One more thing. It seems like when I run macro, everything works flawlessly but I lose the undo button at top. I need to have that function back in case someone doesn't mean to type in a change.

[sktneer]

The macro will be run automatically when a change occurs in the targeted range and worksheet Undo will be disabled. One way around this is you can code a macro like this ...

The scenario would be like this...

1). if someone tries to change the values in the targeted range, the target cell will be highlighted and the changed value will not be accepted and the cell will always display the original value. Like if in one cell in the targeted range is 4.99 and someone tries to change it to 5.99, the code will highlight that cell to tell you that somebody has tried to change the value of this cell and place the original value 4.99 again in that cell. So the user cannot change the values of the targeted range.

2). If the cell in the targeted range is 4.99 initially and user type 4.99 (same value) in that cell, nothing will happen because he did not change the value of the cell.

If this is the scenario you are willing to work with, you can try following code...

Please Login or Register  to view this content.

[eguirocker3]

Ok I like the original scenario where it highlights cell and records their new value. I will have to make do with the fact that undo will be disabled. Thanks again.

[eguirocker3]

Is it possible to revise this macro where if a cell is blank and someone enters a price, it will also highlight blue? So it will highlight blue if someone makes a change OR enters a value into a blank cell within columns J and W.