Symbol alignment in mulitple cells

[Tcurtis]

I use an excel sheet to track the development of personal during training. I used multi colored triangles to track progress day to day and month to month. I have always had trouble aligning the triangles in each cell so that it appears to be in the middle of the cells. Is there an alignment tool or way to align the shapes in the cells so they are centered automatically instead of me just "eye balling" them? Usually my sheets are small enough to do this manually but lately they have grown in the amount of rows and columns I am using.

Thanks

 

[Matt Rogers]

Hi.

Use the Customize Excel Conditional Formatting Icons "Directional".

 

[Tcurtis]

Works great, I forgot about those. I have been doing them manually for so long I sometimes forget some of the automation. Thanks

 

[Matt Rogers]

Thanks for the feedback and good luck.