Excel Formula Question

[shaticus]

I am Working on a worksheet in Microsoft Excel for a friend. He wants a cell to always contain a word. But if a value in the cell next to it reaches a certain value the cell with the word in it should change colors.(IE. If the word is "computer" and the value goes above 50 the cell with computer in it should change to the collor red.) I thought an if formula and conditional formating would work but no such luck. If the value is true or false the true formating is always applied.

ANy help is greatly appreciated.

[alfie2]

try this:
http://www.mrexcel.com/tip054.shtml

or you can do the hard way with visual basic function:" RGB"

and for text specifics:
-------------------------------------------
Select the cells you want to apply formatting.
Goto Format --> Conditional Formatting
Condition 1:
Formula Is --> =NOT(ISERROR(SEARCH("computer",range)))
Format...
Colour = Red
OK .. OK
------------------------------------------
note: "range" should be something like A1:A50 for ex.

[shaticus]

Thanks