Correct Syntax for Changing Color of Cell Based on Value
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
|