Macro Codes for Conditional Formatting

[jjsauer]

Can anybody give me a reference with the different possible codes used in creating your own conditional formatting in a macro?

I need to conditionally format cells, based on a different column of cells having a particular letter, to have a black up or down arrow.

Thanks for any assistance!

 

[Andrew Poulsom]

Have you tried recording a macro while conditionally formatting manually?

 

[jjsauer]

I have...its not exactly what I need and I am not sure how to modify to get it to reference another cell. It may not even be possible to use icon sets when referencing other cells...

 

[Andrew Poulsom]

No, you can't reference other cells with icon sets.

 

[jjsauer]

Do you know any other way to add arrows to a cell...maybe as an image? Then I can try to work it out to what I need visually...

Thanks

 

[Engineer Joe]

If you're going to reference another group of cells with the formatting, is it possible to come up with a formula for the cells you want to have for the visual indicators? For instance, you could use a formula in the cell using an if or iff function, and then conditionally format the cell based on the formula. And if you want to hide the result of the formula, you could make it the same color as the cell maybe.

 

[jjsauer]

Ah, I had tried looking into something similar to that...but I still need the number too...

Can I reference both a cell and a conditional format?

 

[Engineer Joe]

Maybe there's something I'm not understanding about the question, but I just tried this out with a column of random data between 0-500. In another column, I just used a formula that referenced the other column. Literally, I the value I put in cell B1 the formula: =A1. Then I applied that down the column. Then, in conditional formatting, I used the 4 gray arrows, and filled in 250 for all of the quantities and clicked the checkbox indicating that it should show the icon only (not the result of the formula, but you can also choose to show the number). The result was either an up arrow or a down arrow. Is this different than what you are trying to achieve?

 

[Andrew Poulsom]

Maybe you can adapt this:

http://www.andypope.info/tips/tip011.htm

 

[jjsauer]

I did read something once about using special fonts to get arrows...I suppose this will work, I was just hoping for a conditional formatting macro because it would be much simpler..

Thanks for all the advise, direction, and help