Macro to run whenever any cell in the spreadsheet is modified

[theoldebrewer]

I need to use a macro to apply colours to a cell based on the cell value and if that cell value is changed subsequently I want the macro to run again - is this possible, please?

[xladept]

Sure - you can use the worksheet change event and color it by the cell's new value.

[theoldebrewer]

I am using Excel 2000 - does that have worksheet change event?

[xladept]

Yes - bring up the code module for the worksheet where you want the code to run and choose worksheet from the leftmost drop down - it will bring up the selection change event - from the right most dropdown you can then choose the Worksheet_Change event - it will give you the code envelope and you're ready to start coding
Target is automatically the cell selected ( a range).

[JosephP]

you can also use conditional formatting without any code subject to a 4 condition limit (3 for conditional formatting plus the default cell formatting)

[theoldebrewer]

I found the code sheet but no dropdowns - I am Excel 2000

Yes - bring up the code module for the worksheet where you want the code to run and choose worksheet from the leftmost drop down - it will bring up the selection change event - from the right most dropdown you can then choose the Worksheet_Change event - it will give you the code envelope and you're ready to start coding
Target is automatically the cell selected ( a range).

[theoldebrewer]

I need 12 colours.....

you can also use conditional formatting without any code subject to a 4 condition limit (3 for conditional formatting plus the default cell formatting)

[JosephP]

in the vb editor you should see the attached. I've highlighted the dropdowns

[xladept]

Maybe by using the terminology "leftmost" and "rightmost" I, inadvertently, mislead you as there are only two as shown by JosephP's pic of the envelope I described????