The People of Virginia VS Grabigial BanBerger | ARFCOM News

[ARCHIVED THREAD] - Excel Problem

Posted: 10/9/2009 12:22:39 PM EDT

I have an Excel spreadsheet that I am looking to see if I can do a tweak to.

I have a "Quote" field that is numerical and I want to know if there is a way that I can have the field directly to its right put the word "Overage" in red letters if the "Quote" field has gone negative.

Is there a way to do this? I tried messing around with the logical formulas it has, but I am retarded when it comes to Excel.

Posted: 10/9/2009 12:24:30 PM EDT

[#1]

if field B5 is your number use

IF(B5<0,"OVERAGE","")

Posted: 10/9/2009 12:25:29 PM EDT

[#2]

=if(A1<0,"Overage","")

replace the A1 with whatever your quote cell is.

Posted: 10/9/2009 12:26:30 PM EDT

[#3]

=IF(A1<0;"OVERAGE";"")

Got beat. Also, change the font properties for the cell to make it red. If you want other text there that is not red when the value is positive, use conditional formatting.

Posted: 10/9/2009 12:26:47 PM EDT

[#4]

= If function

= if x<0

"Overage"

""

or something like that

Posted: 10/9/2009 12:30:38 PM EDT

[#5]

AWESOME!! Thanks guys!

Posted: 10/9/2009 12:30:39 PM EDT

[#6]

Quoted:
if field B5 is your number use

IF(B5<0,"OVERAGE","")

In addition to this, use the Conditional Formatting menu under the Format menu at the top to make it turn red.

Posted: 10/9/2009 12:35:41 PM EDT

[#7]

Quoted:

Quoted:

if field B5 is your number use

IF(B5<0,"OVERAGE","")

In addition to this, use the Conditional Formatting menu under the Format menu at the top to make it turn red.

This.

Click on the cell, click "Conditional Formatting" (format menu for old versions, on the home ribbon for 2007)

Select "Format only cells that contain..." to input your rule

[ARCHIVED THREAD] - Excel Problem

Warning

Confirm Action

[ARCHIVED THREAD] - Excel Problem

[ARCHIVED THREAD] - Excel Problem