Forum Discussion
Solved
Conditional Formatting if % sign is Present in Cell
I'm hoping someone can help me with this question. I'm definitely self-taught in excel, so please excuse if the answer is obvious. I have statistical tables where many lines just have percentages in the cells with 2 decimal places and a percent sign. I also have other cells that have numbers with decimal places that do NOT have a percent sign in them. I want to drop the decimal places down to 0 ONLY in the cells that have the percent sign in them. Is this possible? If so, please help a lowly learner...
HansVogelaar Thanks so Much!!! It worked perfectly!
2 Replies
Select the range you want to apply this format to.
The top left cell of the range should be the active cell in the selection.
Let's say this cell is A1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=LEFT(CELL("format",A1))="P"
Remember, A1 is the active cell in the selection.
Click Format...
Activate the Number tab.
Select Percentage in the Category list.Set the number of decimal places to 0.
Click OK, then click OK again.HansVogelaar Thanks so Much!!! It worked perfectly!
