I have a column with percentages in it, and I want to have the color of each
cell change based on values. If the percentage is greater than 50 then I
want Blue. If the percentage is 25 to 50 I want red. If the Percentage
is less than 25 I want black. I guessed at the following syntax for a
Custom number type, but Excel is rejecting this:

[Blue][50]Percentage;[Red][25]Percentage; Percentage

What would be the correct syntax?

A further refinement on this is that I don't want more than one tenth of one
percent precision, so the template would be 00.0%.

--
W

Maybe something like:
[Blue][0.5]0.00%;[Red][0.25]0.00%;0.00%

(notice that the numbers are now decimals--not whole numbers.)


W wrote:

I have a column with percentages in it, and I want to have the color of each
cell change based on values. If the percentage is greater than 50 then I
want Blue. If the percentage is 25 to 50 I want red. If the Percentage
is less than 25 I want black. I guessed at the following syntax for a
Custom number type, but Excel is rejecting this:

[Blue][50]Percentage;[Red][25]Percentage; Percentage

What would be the correct syntax?

A further refinement on this is that I don't want more than one tenth of one
percent precision, so the template would be 00.0%.

--
W

--

Dave Peterson

: [Blue][0.5]0.0%;[Red][0.25]0.0%;0.0%

(I didn't notice the last sentence of your original post.)


W wrote:

I have a column with percentages in it, and I want to have the color of each
cell change based on values. If the percentage is greater than 50 then I
want Blue. If the percentage is 25 to 50 I want red. If the Percentage
is less than 25 I want black. I guessed at the following syntax for a
Custom number type, but Excel is rejecting this:

[Blue][50]Percentage;[Red][25]Percentage; Percentage

What would be the correct syntax?

A further refinement on this is that I don't want more than one tenth of one
percent precision, so the template would be 00.0%.

--
W

--

Dave Peterson

Use conditional formatting.

In Excel versions 2003 and befo

Select the range of cells you want to format. Assume this range is A1:A10.
Goto the menu FormatConditional Formatting
Use the Formula Is option
Condition 1
Formula Is: =A10.5
Click the Format button
Select the Font tab
Set the color to BLUE
OK
Click the Add button
Condition 2
Formula Is: =A1=0.25
Click the Format button
Select the Font tab
Set the color to RED
OK out

--
Biff
Microsoft Excel MVP


"W" wrote in message
...
I have a column with percentages in it, and I want to have the color of
each
cell change based on values. If the percentage is greater than 50 then I
want Blue. If the percentage is 25 to 50 I want red. If the Percentage
is less than 25 I want black. I guessed at the following syntax for a
Custom number type, but Excel is rejecting this:

[Blue][50]Percentage;[Red][25]Percentage; Percentage

What would be the correct syntax?

A further refinement on this is that I don't want more than one tenth of
one
percent precision, so the template would be 00.0%.

--
W