Conditional statement

**captedgar** · 01-27-2010, 03:39 PM

Hi there

I have an set of conditional statements to check which i'm not sure whether to use IF or CASE statement. can u please advice

Find below the code

Please Login or Register  to view this content.

I'm passing strcode to another function which generates email so

Please Login or Register  to view this content.

But for some reason the right condition is not getting picked up

**Richard Buttrey** · 01-27-2010, 04:00 PM

Hi

Without knowing which condition is being picked up and which condition you think should be picked up it's difficult to advise. Don't worry at the moment about the difference between If..Then and Select Case structures, the first thing to reconcile is the basic problem.
Can you upload an example workbook so that we can see the problem in context. If you do add a note saying what you expect should be happening.

Regards

**captedgar** · 01-28-2010, 07:17 AM

Hi there

I have attached a simple spreadsheet with a table in it
All the cells except the headers in the tables are conditional formatted so that
if i select a cell in the table as No, the colour of the cell turns red
if i select Yes, the cell color turns green and
if i select NA, the cell color turns orange.

My code is below

Please Login or Register  to view this content.

When i need to select a particular row as Yes or NA, my IF statement is breaking logic in
picking the right strcode value independent of whatever the values are in the other cells in
the table

Please advice