How to record a macro with conditions

[cbsalt]

I've searched the web fruitlessly looking for instructions or guidance for recording a macro utlizing conditions. I'm trying to learn about macros, and I've found it incredibly helpful to record them and then analyze what each part of the code does. I'm extremely confused about writing code for conditional statements, and I'd really like to record a macro to learn more about this.

However, I can't figure out how to actually record the macro. For example, I'd like to record a macro that checks to see if A5="yellow". If it equals "yellow", I'd like "Orange" to display in B5, else I'd like B5 to be blank.

The actual "tests" and/or "values f true", "values f false" don't matter. I'm just interested in learning how to record a macro this way to be able to evaluate and analyze the code that is written to perform the conditional function.

Anybody know of any tutorial sites or any other information that might help me out? I'd really appreciate any help!

Thanks!

[StephenR]

You can't record a macro like that, other than recording yourself entering the appropriate formula. For that you need to know the formula so it's a vicious circle.