How to conditionally format cell as percentage?

[vanclute]

I'm using Mac Excel 2011.

It seems that CF only supports style changes like color, font, etc. and not formatting changes like currency, percentage, etc. If this is not the case, how does one do this?

Assuming my above assumption is correct, how can I achieve the following:

I have two columns, one that labels the type of data that is in the second column, and then the data itself. For instance:

A                B
bids          0.0012
spreader   on
potency    0.75

I would like to format the data in column B, based on the content of column A. So for instance B1 should be currency, B2 should be text ("General" would be fine), and B3 should be Percentage.

Thanks for any pointers!

 

[yky]

I entered 1 in A1 and 0.5 in B1. Then, I set a condition "=A1=1" on B1 and set the B1's format to percentage (all under Conditional Formatting). When I changed the value in A1 to 1, B1 became 50.00%. If I put 2 in A1, B1 showed 0.5. This proves Conditional Formatting can handle format changes, at least for percentage.

 

[vanclute]

set the B1's format to percentage (all under Conditional Formatting).

But how can you set that under CF when there is no option to do so? CF (remember, I'm on Mac in Excel 2011) does not offer any formatting options other than stylistic ones.

 

[yky]

Sorry! I completely forgot that you use Mac. If you click on Conditional Formatting../New Rule, do you see the dialog box as shown in the following link?

https://officeblogswest.blob.core.windows.net/wp-content/migrated-images/44/8206.IMAGE 05.png

If you do and you click on the format button, do you see the following dialog box?

http://www.spreadsheetsmadeeasy.com/wp-content/uploads/2012/05/Excel-conditional-formatting-04.png

 

[vanclute]

Not quite but similar...

Image #630400 - CtrlV.in Image Hosting

If I choose Custom Format I get this:

Image #630401 - CtrlV.in Image Hosting

There is no way that I have found to specify formats like currency, percentage, etc. Only stylistic (colors, fonts etc.) changes. Am I just not seeing it somewhere?

EDIT: Of course I would also select the "Use formula" option, which I neglected to show.

 

[yky]

Well, looks like you need to wait till the next upgrade. I'm surprised to see that after all these years, the discrepancy between Windows and Mac version is still considerable.

 

[vanclute]

Yeah there are a number of "little things" like this that are different and at this stage, feel like they always will be. I guess I'm just SOL on this. How annoying. Sigh...