Format a cell based on multiple checkbox combinations

Hi there,

Is it possible to have a macro that allows for a combination of IF and OR statements? I want to have a cell change format (color, bold, doesn't matter) based on whether certain factors are true. The trouble is, there may be more than one combination of factors that could lead to that cell being formatted. In laymen's terms:

If A1, A2, & A3 are TRUE, OR IF A1, A2, & A4 are TRUE, OR IF A2, A4, A5 are TRUE . . . .then format B1.

Help is much appreciated!!

Re: Format a cell based on multiple checkbox combinations

Quote from pike;800324

Hi corcelle
you can add layers to conditional formatting

You can? I had no idea . . . thank you! Now to figure out how. Do you have any examples?