VB Conditional Formatting Question??

[Jay3]

Can anyone help with me with the attached.

This code basically uses conditional formatting in an excel spreadsheet as I cannot not use the conditional formatting option as there are more than 3 conditions!

It works fine if you enter the values 1 at a time, however, where people use the copy function, errors flash up, can anyone tell me why this is and what I need to do to fix it?

Please Login or Register  to view this content.

Thanks
Jay3

[royUK]

maybe

Please Login or Register  to view this content.

[Jay3]

Thanks for the code, it kind of works but there are a couple of issues.


It doesn't seem to recognise the two distinct ranges (Issue 1)

When you delete a value, it doesn't remove the formatting (Issue 2)

Can you help with this?

[foxguy]

Thanks for the code, it kind of works but there are a couple of issues.


It doesn't seem to recognise the two distinct ranges (Issue 1)

When you delete a value, it doesn't remove the formatting (Issue 2)

Can you help with this?

To remove the formatting put icolor = 0 in the Case Else

If the Union() doesn't work then break it into separate checks.

Please Login or Register  to view this content.