VBA for MORE Conditional Formating Excel 2003
Hello Friends....:help
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...
:bug: Not sure If I explain this clearly enough..:dunno
VBA for More Conditional Formatting Excel 2003
Wow, great, thank you my friend. It works wonderful. I was :banghead: last night trying to figure it out. I'm grateful.:friends: HAve a great day from all of us here in the Tropical Island with many many miles of sandy beaches and clear blue warm waters.....:thumb
VBA for MORE (HELP) Conditional Formating Excel 2003
Quote:
Originally Posted by xld
Which tropicall island? I would be jealous but I suffer in the heat :)
Puerto Rico...The Shinning Star of the Caribbean. It's close to about 95 in San Juan, but I am in an A/C office so it is KOOL....
:dunno OK. The code works great BUT i forgot to mentioned another condition which i needed. The condition I have now which you greatly helped is changing column C cell to a color based on the given condition of column B, which is great and it works fine. The other condition i need is that the conditions on column B when it is met can change the color of the cell on column G...
Example: This is what it is doing right now: Colomn "B" row 4 cell has Germany, it changes color on column "C" row4 cell to green.
Colomn "B" row 5 cell has "Italy", I need it to change color on column "G" row 5 cell to blue and not colum C row 4 to green.
I offset the colomn son the ---.Offset(0, 3).Interior.ColorIndex = iCol---
but it changes the first condition.:thumb