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

jjsauer

Board Regular
Joined
Jan 11, 2012
Messages
58
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!
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top