Conditional Formatting

[mswhiteside]

Hello everybody.

I need some help. i'm trying to use conditional formatting for about 6 different conditions. what code can i use to make this happen, since you can only use the default conditional formatting for 3 conditions.

Thanks

[Killer42]

I need some help. i'm trying to use conditional formatting for about 6 different conditions. what code can i use to make this happen, since you can only use the default conditional formatting for 3 conditions.

I've often wondered the same thing.

The only answer I've come up with is to put some VBA code somewhere such as the Worksheet_Change event procedure for the worksheet in question. Do your condition checking there, and set the format of the cell appropriately.