Applying 'Live' conditional formatting within VBA code

[protocoledu]

I've had to use some short VBA code in order to create more rules, but it will only update if i actually click on the cell, is there anyway to make this 'live' so when i add data it changes automatically;

Please Login or Register  to view this content.

[Palmetto]

You need to use the Worksheet_Change event. You currently have the code set to run under the Worksheet_SelectionChange event - which means the code only "fires" when you change from one cell to another within the intersecting range you have defined.

[protocoledu]

Hi Palmetto, thanks for the reply but I did try the change to 'change' but it doesn't even change colour not even when I click into the cell!!

EDIT - Sorry I did forget to mention I'm working with Percentages, would this make a difference?

[protocoledu]

Does anyone have any clues on this one at all??

[Palmetto]

Your code in the worksheet_change event works for me.

Please Login or Register  to view this content.

[protocoledu]

Palmetto, thanks for your help in this but it doesn't seem to like it when i put a simple % formula into the cell.

I've attached what I mean!