Excel question

[Liger86]

This is really simple probably but i cant figure it out.

When formating a cell into a Currency; if the value in that cell is negative it changes to red. How can I make a cell red or any other test color if say the value is "5" or below?

Thanks

[anonytmouse]

Select the cell. On the menu, click Format->Conditional Formatting... Use dialog.

[Liger86]

Thanks, im just a bit intoxicated right now,

[twomers]

Doing Excel when intoxicated ... well that's a first! You could always use an if statement ...

if ( C3<5, VALUE TOO LOW, OK )

which, I think will write it into another cell, but as anonytmouse said, the conditional formatting is the way to go with what you want.

[Fordy]

Format->Cells->Numbers->Custom->Type:

#,##0.00;[Red]-#,##0.00