Is there a Justify IF function?

[Daneshav]

I have a range E15:O87 that uses an IF and lookup function in each cell. It returns either a number or N/A. If it returns N/A, I would like it to be centered. If it returns a number I would like it to be left justified. I'm not really sure how to use code but if that's what it takes, I can follow dirrections to get it implemented. How should I go about doing this?

Can anyone help?

-Dani<!-- / message -->

 

[taigovinda]

Welcome to the board!

You can do this with conditional formatting. Use the conditional formatting formula:

=iserror(E15)

...and the format to be centered. Then manually put all the cells to the left side. Those that return errors will be centered. Hope that helps. You can get to conditional formatting by selecting the cells and alt+O,D

 

[cboshdave]

What is the purpose for centering N/A values. By default, Excel will left align text and right align values. Maybe if I understood the purpose for centering the value, I could give you a workaround? What if you pull N/A values into another column with a formula and then Center that column??

Another option would be to write a macro that will check for the value of each cell and then format it appropriately. A little more involved than a formula though.

cboshdave

 

[shg]

You can do this with conditional formatting.

Conditional formatting doesn't support cell alignment as a formatting option.

 

[taigovinda]

Conditional formatting doesn't support cell alignment as a formatting option.

Oops!

 

[Fazza]

Format as text. So, CTRL-1, 'number' tab, category 'Text'.