Hello.

Is there a way to bypass Conditional Formatting if 1) you need more than
three different formats or 2) you have a problem with people
cutting/pasting information which removes the conditional formatting?

I have a spreadsheet setup with conditional formatting. If cell C4
meets a specific criteria, then cells C3, C4, C5, C6 and C7 all are
formatted as designed. I would like to find a formula/VBA script that I
could setup and use that would accomplish the same task, but not use
Conditional Formatting.

Any and all help would be greatly appreciated! I am pulling my hair out!!

Thanks.

Bruise