Most valuable professional
  • Hot Topics

Excel Change cells number format off an other cells value

Hi, I am using an if statement that depending on the value in B1 is a 1 or a 2 will ether return a number or a Percentage. I am trying to get excel to change the format if the value in b2 is 1 to a % format and if it is 2 to a number format. I have tried using these two rules in conditional formatting but it is not working and getting "stuck" in one of the formats =$B$1=2 format as Number =$B$1=1 Format as Percentage Here is an example that should be formatted as a percentage Excel 2007 1 2 3 4 Summray Worksheet Formulas Cell C3 D3 C4 D4

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of November 1, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel