Working with colour cells

[Immundispure]

Hello,

I am fairly new to working with Excel, i want to know if it possible to have cells show in colour. I'll explain in a little more detail.

I want the cell to; Show in red for cells that are lower then a profit value, and green for cells that are above a profit value

Not really sure how to explain what i want to do, basically the spread sheet is so i can easily see where competitors are beating my prices and when they are not.

Is this even possible?

Andrew

[Tony Valko]

You can do that with conditional formatting.

We'd need more detail to be able to make a specific suggestion.

Tell us what cells need to be formatted and what is the target value.

[Immundispure]

Hard for me to explain, as i am fairly new to Excel.

Basically, im wanting the spreadsheed to display in red a competitor thats beating my prices. So if their selling prices are lower then mine in the spread sheet, i want it to detect and flag it as red. i just need to know how to get the cell show red if a value is less then my price. This probs doesnt help?

So if Column A is my price and column B is competitors price, i need column B to detect if its lower or high then column A, red for lower, Green for higher

[Tony Valko]

Here's an example...

Let's assume this is your data in the range A1:D2...

Yours...Comp1...Comp2...Comp3
..50.......52.........57........48...

Select the range B2:D2

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=AND(N(B2),B2<$A2)

Click the Format button
Select the desired style(s)
OK out

[Immundispure]

Thankyou for the help, appreciate its frustrating with the limited knowledge i have, would you mind explaining to me what teh parts of the formula do?

=AND(N(B2),B2<$A2)

[Tony Valko]

The AND function tests that all of it's arguments are TRUE. The arguments are:

N(B2)
B2<$A2

N(B2) is making sure that there is in fact a number entered in cell B2.

B2<$A2 is testing that the value of cell B2 is less than the value of cell A2.

If both of these conditions are TRUE then the result of =AND(N(B2),B2<$A2) will be TRUE and the conditional formatting will be applied to cell B2.

[Immundispure]

Oki that i understand, but how to i get it to show in colour? as in if competitor value C2 is lower than my price B2, if so shows red, it not shows green?

Very thankful for this

[Immundispure]

oki im thinking that this may make my life easier, if i just use one colum say column F and i wand it to show green if number greater then 0 and red if lower then 0, best way of doing that?

[Tony Valko]

How about posting a SMALL sample file and show us what cells should be what color.