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
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
From Ukraine with love!
Internationally known – widely respected
- Digitally yourz -
Select the cell. On the menu, click Format->Conditional Formatting... Use dialog.
Thanks, im just a bit intoxicated right now,
From Ukraine with love!
Internationally known – widely respected
- Digitally yourz -
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.
Format->Cells->Numbers->Custom->Type:
#,##0.00;[Red]-#,##0.00