IF < [RED] or IF > [GREEN]

Brad1m

New Member
Joined
Oct 16, 2010
Messages
23
I dunno guys, I could spend my life looking through all the videos in excelisfun and mrexcel, they are awesome but I just dont have the time nor the knowledge to know what function I am looking for???

I would like the Text or should I say number in certain Cells be RED if its below the value of Cell D3 and GREEN if its above the value of cell D3.

I have looked through IF and Boolean stuff but just can't piece it all together and probably barking up the wrong tree all together.

Help again please guys...

:confused:
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
That's conditional formatting..

What if the value is actually = D3 ? Is that another color?
Or perhaps
< Red
> or = Green


Also, what version of Excel?
 

Brad1m

New Member
Joined
Oct 16, 2010
Messages
23
Thanks for the reply jonmo1

Pretty sure its excel 2007

and if the value is the same as D3 it can be green which will mean break even.

Red is meant to indicate loss and green is meant to indicate profit.

Some tools in the shed are sharp, I'm more like the head of a hammer...:LOL:
 

Desu Nota from Columbus

Well-known Member
Joined
Mar 17, 2011
Messages
556
Brad,

Condition formatting is very simplistic. Anyone that understands <, >, and = to can do it without any knowledge of coding. If you haven't figured out what jonmo1 is talking about, condition formatting is under the Format menu in Excel.

Set the two conditions to what Jonmo1 said and your quandry is solved.
 

Brad1m

New Member
Joined
Oct 16, 2010
Messages
23

ADVERTISEMENT

Thanks Desu Nota from Columbus,

I don't want to come across as insubordinate but I don't think conditional formatting is what I am looking for???

Seems like it will highlight the cells and all I want to do is highlight the text or numbers in the cells

I will do my best to explain.

Lets say I buy option contracts with a value of 42c and at that price I can afford 11 contracts with a total value of $4,620.00 ($4,620 is in cell D3)

If the option price falls below .42 then every number below .42 or simply 42 will be RED
eg; 415*11 = $4,565.00
410*11 = $4,510.00 and so on

When the number is equal to or above the value $4620.00 then it's green this column will start with value 0.000 and run through the 42 and all the way to 10.000 or more

Some options may cost 550.000 in cent values.

MAN? Am I making any sense at all????
 

Brad1m

New Member
Joined
Oct 16, 2010
Messages
23
=A11*1000*C$8 Gives the appropriate figures to work with, so I'm thinking something like this

=IF((A11*1000*C8)<C8,[Red],(A11*1000*C8)>C8,[Green]

Might do what I want???

Can anyone help me sort this out, I have seen it done but don't know how to do it myself?
 

Brad1m

New Member
Joined
Oct 16, 2010
Messages
23
=A11*1000*C$8 Gives the appropriate figures to work with, so I'm thinking something like this

=IF((A11*1000*C8)<c8,[red],(a11*1000*c8)>C8,[Green]

Might do what I want???

Can anyone help me sort this out, I have seen it done but don't know how to do it myself?

I meant =IF(A11*1000*C8)<<c8),[red],((a11*1000*c8)>C8,[RED],(A11*1000*C8)>C8,[GREEN]


Just bungling my way through.</c8),[red],((a11*1000*c8)></c8,[red],(a11*1000*c8)>
 
Last edited:

Brad1m

New Member
Joined
Oct 16, 2010
Messages
23
Thanks Guys: Should have listened to you from the start, the answer was in cond formatting... I just couldn't work out how to use it.


Too many choices and not enough knowledge... :eek::eek:

Got there in the end (couple of hrs and a few carefully chosen words later) lol
 

Watch MrExcel Video

Forum statistics

Threads
1,108,817
Messages
5,525,068
Members
409,617
Latest member
Lenaf

This Week's Hot Topics

Top