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 ...
HansVogelaar Thanks so Much!!! It worked perfectly!
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!