I need to know how I can change the fill color of a range.

Now that is the simple part.

But I need to make a function so that it can be changed by two
different cells.

One cell will change it one color the other cell will change it
another color.

Example: in row three cell a3 has the word "pending"(pending can be in
ne row) in it. Since a3 = pending the color of the row (range from a3
to q3) is yellow (row).
If a3 < "pending" its white (row) also if a3 = e or d color the row
(range from a3 to q3) red (row)
Now if c3 = "yes" then change the row (range from a3 to q3) color to
green if it is no leave row alone.

Also this can happen in ne row so and must be row specific.

i can make it it hapen but not be row specific

i could use ne help please.

thanks

exor