Conditional Formatting to format cells to Percentage

[mikehk]

I like to format cells to Percentage if
cell J2 is %

Please correct me, I tried conditional formatting
=$J2=%

[mikehk]

Got it...it should be
=$J2="%"

[mikehk]

since the cells are formatted to Percentage, numbers
get displayed as 0.90% ...how to remove % symbol

[mikehk]

or since my numbers are 0.001, can CF do
IF($J2="%"), $G2:$I2*100

[JeteMc]

It would possibly help if you could upload a file and show us what you have then manually show us what you want.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

[GeoffW283]

A bit of information while waiting for you to upload your file as recommended by JetMc:

Relative to post #4, your CF formula will not work. A CF formula needs to evaluate to either TRUE or FALSE. If TRUE then the specified cell formatting will be applied. CF can't change the value of a cell.

It is possible via formula to determine whether a cell is formatted as a percentage. The following CF formula evaluates to TRUE if J2 is formatted as a percentage:
=LEFT(CELL("format", J2), 1)="P"
Note that there is a slight anomaly in that changing the format of J2 does not precipitate a recalculation.

Your post #1 request seems to be satisfied if you apply the above CF formula to cells G2:I2 and apply as part of the CF the number format "Percentage". Then if you change the format of J2 to or from "percentage" this will also change the formatting of G2:I2 (as noted above you will need to press F9 or do something else to cause a recalculation)

In post #3 you want to remove the "%" from a cell formatted as a percentage. As far as I know you can't do that and it would be terribly confusing - how would you tell the difference between a number value and a percentage??

The attached workbook implements the CF discussed above.

Hope this helps a bit.