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!
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!