Using conditional formatting to find the respective remarks

[excelplshelp1]

Anyone can help me? I trying to give remark to my Profits and Loss amount with Poor, Good, and Excellent.

For example if my amount is more than $10000 it should be remark Excellent automatically by excel in the cell beside. How am I able to do this with conditional formatting in Excel 2007.

<example>

A B
1 10000 Excellent
2 (500) Poor
3 8000 Good


Criteria: Poor is less than 0, good is between 0 to 10000 and Excellent is above 10000


How can I make excel put the respective remarks automatically whenever i key in a different amount?

[oldchippy]

Hi,

You can do this with a formula in the adjacent cell based on your criteria

Criteria: Poor is less than 0, good is between 0 to 10000 and Excellent is above 10000

=IF(A1<0,"Poor",IF(A1>=10000,"Excellent","Good"))

[excelplshelp1]

I want to use conditional formatting instead. Is that possible?

[oldchippy]

Not to write formulas, but take a look here for a demo of CF in 2007 may be this will help?

http://office.microsoft.com/en-us/ex...655491033.aspx

[Dav]

If the values are to appear in a cell the if statement you have been given is the correct answer. It is what you asked for, why would doing it by conditional formating make any difference?

If you wished to have the cells shaded dependent on the result say value <0 format red, value>10000 shade green, othrwise the cells are orange, you would use conditional formats

Regards

Dav

[Cheeky Charlie]

Alternative formula:

=LOOKUP(B1,{-9E+307,0,10000},{"Poor","Good","Excellent"})

[oldchippy]

Nice one Cheeky Charlie

[excelplshelp1]

“Poor”, profit between $0 and less than $10,000 as “Good” and above $10,000as “Excellent”. Automatically highlight remark “Poor” in red.

This is the criteria....

So is there anyway to use conditional formatting now? Thanks to all :D

** Ive upload a 2003 version for easier reference. Will be great if you all can show me in excel file. Thanks

[oldchippy]

Hi,

I've used our friends formula and added an error trap in case you have blank cells in column A. Take a look in conditional formatting for the formula to highlight in red.

Does that help?

[excelplshelp1]

Hi,

I've used our friends formula and added an error trap in case you have blank cells in column A. Take a look in conditional formatting for the formula to highlight in red.

Does that help?

Thanks... I figure out already!!