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
|
Similar Threads
