IT WORKED!

The Dollar Signs did the trick.

Thank you so much, and to the gentlemen for their suggestions as well.

You people are geniuses.

Thank You.
Lee


"JulieD" wrote:

Hi Lee

1) which cell are you putting the conditional formatting on
2) no " " in the formula
3) when the information AA10 and AB2 is selected via the drop down list are
the resulting values in these cells numbers or text - use
=ISNUMBER(AA10) or =ISTEXT(AA10) to answer this question, if they are text
try
=AND($AA$10="6",$AB$10="2")
if numbers try
=AND($AA$10=6,$AB$10=2)

Cheers
JulieD

"Lee" wrote in message
...
Thank you for the suggestions. I'm sorry for my ignorance - way over my
head
here.

I believe the Conditional Formatting will do the trick (I didn't even know
you could use a formula there).

I've tried the formula "=AND(AA10=6,AB10=2)" and conditionally formatted
to
change the background color of this cell to red when true.

However even when AA10=6 and AB10=2, the cell color still doesn't change?

Could it have something to do with the fact that I'm using combo box
selections to make AA10=6 and AB10=2?

Thank you guys so much for your help.
Lee





"Lee" wrote:

Does anyone know of a way to check for a value in two different cells,
and if
a certain combination of values exists, change the format of another
cell?

Any help would be much appreciated.

Thank You.