Formatting desired cells

[rupeshkumar_rj]

Used the below code for formatting the desired cells on changing the content of a particular cell. This worked fine only when I clicked on the cell after changing the cell content. I have used a list box to change the value of that particular cell. Trying to do a simple thing ...
-When a cell's (say A2) value is changing from "one" to "two", the font color of the adjacent cell/any other cell (say B2) should change from red to green.

anybody ? who can help

Please Login or Register  to view this content.

[jasoncw]

I have some suggestions.

1. Rather than using the selection change event, I would use the change event.

2. Change all 'cel' references to 'Target'.

3. I also included the LCase function so that the case doesn't have to match (i.e. "major", "Major", and "MAJOR" will all accomplish the same).

Here is the revised code:

Please Login or Register  to view this content.

[rupeshkumar_rj]

working superb .. thanks Jason

[jasoncw]

Glad I could help.