number to percent format

[Arjun328]

hi,
i am tring to conver number to percent but its not happening its showing as numbers please help me out this and also i want to aply a condition if based on percent if above 50% the cells should be red and for DIO if its > 30 days it should be red when i am tring in F8 its working but when i hit F5 its showing as numbers

 

[baitmaster]

Welcome to the board

In Excel there is a distinct difference between the number and the format. The number is the actual value stored in a cell, and the number format only changes how this number looks. No matter what you do to the formatting, you can still work with the underlying number and swap formats where necessary (note: this is also very relevant when working with dates)

So for a value between 0 and 100%, you are only interested in values between 0 and 1, shown using the "%" format. If you are starting from a value of 100 and want to show this as 100%, you need to change two things: divide the value by 100 AND change the number format

My first hunch is that you are not doing one of these things. However since you refer to F5 and F8, and I can't see the image you tried to attach, I'm also guessing this issue is something to do with VBA. Post your code if you need it looked at