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!!