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

[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

 

[Leo Heuser]

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.

 

[Max]

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

 

[Ronny]

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


.

 

[Bob Phillips]

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)

 

[Leo Heuser]

You're welcome, Ronny.
Your feedback is appreciated

LeoH

 

[Ron Rosenfeld]

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

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

 

[Ron Rosenfeld]

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

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

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



--ron