Can I format fields in a pivot so they stay that way only for that particular field?

[kufta4]

What I mean is, let's say I have a field that I put into my rows in a pivot. This contains numbers and letters. Numbers align on the right, letters on the left. I would like this particular field, no matter where and when I put it in, to always align on the right. Is this possible?

Same would be let's say I have another field I put in the rows. These are all numbers but I want these numbers to show, every time whether I take the field out and put it back in later, to show 0 decimal places. Currently I have 1 then I have 12.45, then I have 7.459 etc. I'd like that to show as 1, 12, 7.

Last example might be, for a specific field in the rows column (this could go for values too), can I conditional format? So let's say in rows I am putting the price of an item next to that item's name. Any item price under $1 I would like to highlight in green. Anything over in red. Is it possible to apply this not to the actual column in the excel sheet, but to the data field in the pivot. So if I replaced that data field with something else, and now item price no longer shows in column F of the sheet and instead isle number does, I don't want those to shade green or red.

Thanks for any help.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[kufta4]

Sample workbook should be attached.

[Pepe Le Mokko]

Nothing attached. Have you used the Go advanced button as recommended?

[kufta4]

Look as thought it never actually attached due to size.

As another side question, is it possible if put in rows to have Week 10 fall behind Week 9 instead of behind Week 1?

Week 1
Week 10
Week 2
Week 3
etc