% figure>then 66.6%=green text, % figure<then 66.6%=red text???

  • Thread starter Thread starter Ronny
  • Start date Start date
R

Ronny

Hi

How do I achieve this in a cell? I know its possible whith
money but how do I make this happen with percentage?

Cheers Ronny
 
Hi Ronny

One way:

1. Format the cell as red text
2. Choose Format > Conditional formatting
3. In "Cell value is" (or similar) choose "Greater than
or equal to" and enter 0.666
4. Pick green text.
 
Try this to format on say cell A1:

Select A1

Click Format > Cells > Number tab > Percentage > 1 decimal place
Click Font tab > Color: red > OK

Click Format > Conditional Formatting

Make the settings under Condition 1:
Cell value is | greater than | 0.666
Click Format button > Font tab > Color: green > OK
Click OK

To copy the format done for A1 to other cells:
Select A1 > double click on the Format Painter (yellow brush) icon
Now you can just select (ie "paint") over any other cell(s), etc
continuously using the mouse
(cursor will turn into "a white cross with a brush")

When done / to cancel, just press Escape to revert cursor to normal
 
Thanks Leo!
It did the trick!


-----Original Message-----
Hi Ronny

One way:

1. Format the cell as red text
2. Choose Format > Conditional formatting
3. In "Cell value is" (or similar) choose "Greater than
or equal to" and enter 0.666
4. Pick green text.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Ronny" <[email protected]> skrev i en meddelelse


.
Click to expand...
 
Ronny,

You need conditional formatting. Check it out in Help.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi

How do I achieve this in a cell? I know its possible whith
money but how do I make this happen with percentage?

Cheers Ronny
Click to expand...

Actually, conditional formatting is NOT required for this. You can do this
with simple custom formatting.

Format/Cells/Number/Custom Type:

[Red][<0.66]0.00%;[Green][>=0.66]0.00%


--ron
 
Hi

How do I achieve this in a cell? I know its possible whith
money but how do I make this happen with percentage?

Cheers Ronny
Click to expand...

Actually, conditional formatting is NOT required for this. You can do this
with simple custom formatting.

Format/Cells/Number/Custom Type:

[Red][<0.66]0.00%;[Green][>=0.66]0.00%


--ron
Click to expand...

Actually, that should be:
[Red][<0.666]0.00%;[Green][>=0.666]0.00%



--ron
 
Back
Top