Hi,

I am trying to figure out how to apply 2 conditions to a single cell. It's
for a scorecard type tracking sheet using a number rating scale to represent
the status.

I want to do both a fill color to represent status (Red, Yellow, Green) and
a directional arrow icon for tracking the trend. I can easily do both
independently using the conditional formatting rules, but get stuck trying to
get them both to work together.

Bascially each color would have 3 arrows associated with it.

Red Fill + up arrow, or down Arrow, or across arrow
Yellow Fill + up arrow, down Arrow, or across arrow
Green Fill + up arrow, or down arrow, or across arrow

any ideas how to do this or an easier way to set something like this up?