I have a user who has a need to use conditional formatting
on more than three conditions. This would be simple if
the condition was only looking at the value of a
particular cell. Unfortunately, what he is doing is more
complicated.

He currently has two conditions set up. The condition
compares the current cells value to another cell. If the
values are equal or the value of the current cell is
greater than the one it's compared to, he wants the cell
to be green. If it's a negative value and equal to the
other cell or less than it, it shows green.

Now... if the cell wouldn't have turned red or green based
on the criteria above, he wants to compare the value of
the cell to a different cell than he compared it to
before. Now if it is greater than or equal to the
compared cell, it would turn a lighter shade of green. If
it were negative and less than or equal to the other cell
it would be a lighter shade of red (pink).

The way he set up the red and green formatting now was
just to set up conditional formatting for the first cell
in the row and when he drags his formula to the other
columns, the conditional formatting has been copied with
the formulas, and the conditional formatting rules have
adjusted with the "drag" so that the formatting is based
on different cells.

I haven't been able to come up with a good solution to
provide him the functionality he wants with four different
conditional formatting options.

Any ideas? I'm at a loss!

Thanks,
Jody