Hello Friends....
I have a worksheet in which one column (B) I have named countries using a vertical look up formula and in column C i have a dollar figure also with a lookup formula that comes from the country looked up in column B......What I want is a conditional format turning the interior cell of COLumn C to turn GREEN whenever a specific country is in column B. In excell 2003 I only have 3 allowances. I need at least 15.

So, if in column B i have Germany, I want Column C to turn green because Germany is in Column B...

Not sure If I explain this clearly enough..