Conditional Formatting Arrows - Centre

[Carly]

I have got a cell which contains conditional formatting using the 3 arrows, but the arrow always appears on the left of the cell. Is there anyway this can be centred?

Kind Regards

Carly

 

[Ruddles]

If you set the conditional formatting to Show Icons Only, you can align the arrows any way you want.

Unfortunately you'll then be unable to see the data which the arrows relate to, so you'll need an additional column which replicates the data.

(I think that's the only way to get round it.)

 

[Carly]

Thanks for your help...that worked perfectly.

Follow on question?

 

[Ruddles]

Q1: How do I...?

A1: Show Icons Only.

Q2: But then I can't see the data?!

A2: Replicate it in a separate column.

 

[Carly]

No need, your reply gave me exactly what I needed. I dont need to see any of the data. Thanks again for your help.