I am able to use conditional formatting for, say, one specific "set" of
criteria, and please forgive, I am a completely noob with any kind of
programming, so you are getting the "layman's" version of the criteria I am
using:
if F21=M21, then turn the cell green.

I got this. This works, using the conditional formatting.

What I need to find out is if I can have it look at multiple criteria, such
as...

"if F19=171 (or cell K21) and F21=K20, then turn the cell green; if F19 is
between 120-170 (or cells L21 and M21) and F21=L20, then turn the cell
green; if F19<=120 (or cell L21) and F21=M20, then turn the cell green"
There are really five different criteria I need to use to shade the cell
green; alternately, both red and yellow, but I have them each separated,
kinda like stop lights. heh.

I don't know if I've made any sense with this in typing... it makes sense in
my head, but I'm not sure I'm translating it out in words properly.
Anyway... any help I can get would be greatly appreciated!
--
Lara