Macro or Conditional Formatting to Place arrows in cells based on a letter in another cell

[jjsauer]

Here is what I need.
I have a column that has percentages, say Column A.

This column already has conditional formatting to change the cell color based on a specific, CAPS letter from another column using this formula: =NOT(ISERR(FIND("A",X4:X235)))

What I now need is another conditional formatting (or macro to create a new format, I just don't know the proper code...see this article to see how that is possible: http://msdn.microsoft.com/en-us/library/bb407306(v=office.11).aspx) to then create an up or down arrow (preferably black) based on a specific, CAPS letter from yet another different column.

I hope someone out there can show me the macro code to figure this out!
Thanks in advance!

 

[jjsauer]

BumP!