Extrapolating Data to determine formatting colour

[vt2009]

I have a problem which my have a simple solution: I have a table of stock executions, to 4 different exchanges. Each exchange has different "tags" that are put on an order. Depending on the tag, the order will be colored RED or GREEN. The tags are different for each exchange and sometimes conflicting, i.e. an "A" on NYSE exchange is RED and an "A" on ARCA exchange is GREEN. Each transaction has the time, stock, price, exchange, and tag. I am not sure how to write the formula to automatically assign a green or red color to the cell. In addition, some tags are numeric values: any value<0 = GREEN, any value >0 =RED.

[NBVC]

You would use conditional formatting from the Home tab, and then Manage Rules.

Can you upload a sample workbook showing your setup and how you want the formatting to be applied?