Excel VBA help

[Diomeneus]

I know the basics of excel, making equations and the like, but I am told that in order to make if statements that control formatting I will have to use VBA. I am completely new to VBA but not to programming as a whole. Any help or pointers to where I can learn about this specific issue would help.

Ideally I'm trying to make it so when the inventory count on the item is 0, the entire row is coloured light grey.

step 2 would be if the "state" column reads "New" then colour it blue, red for "untested"

basically:
IF F44>0 AND D44="New"{
Row44textcolour="blue"
}
ELSEIF F44>0 AND D44="Untested"{
Row44textcolour="red"
}
ELSEIF F44>0{
Row44textcolour="black"
}
ELSE Row44textcolour="light grey"




any suggestions?

[royUK]

You don't need VBA, you can use Conditional Formatting, se

http://www.excel-it.com/excel_tutorials.htm

[Diomeneus]

ah! most excellent! Worked perfectly thank you.

Oh, and this question is a little more stupid. Is there a way to add constraints to a cell? As in your only choices to type in are blank, "new", "untested" or "working" ?

[BigBas]

Yes. You can use a Data Validation.

Go to TOOLS-DATA-VALIDATION. Choose LIST, and list your values separated by commas.

[Diomeneus]

once again, thanks.