Excel 2007 : Coloring numbers of a spec value

[henrik.pettersson]

Hi!
I want the cell D3 to have red numbers if D3<=B3?

B3 is a limit we want to have, and in D3 we write the true value.
If the value we write in D3 is less than the value in B3, the numbers should be red. in otherwise the number should be green.

I have try a lot of diffrent things :-( and are thanksful for any help...
/Henrik

[NBVC]

Select D3 and go to Home tab, Conditional formatting and select Manage Rules...

Click New Rule

Select format only cells that contain

and then Cell Value >> Less than or equal to >> enter: =B3

click Format and choose from Font tab.

Click Ok..

Click New Rule and repeat above with

Cell Value Is >> Greater than >> =B3

and choose from Font tab again

[sweep]

Select Cell D3

On the home tab, go to conditional formatting, and click new rule.

Click "use a formula......."

and enter

=$D$3<=$B$3

then set the format to red

repeat and enter

=NOT($D$3<=$B$3)

and set the format to green.