Find and Replace Text with If Then Condition

I need to find and replace text in certain cells an Excel sheet but with conditions:

For example:
If Cell in Column A="House" and Cell in Column B="Red" then rename Cell in Column B="Dark Red"

Do I do this with a macro? Please help. Thanks.

Originally Posted by charliechez

I need to find and replace text in certain cells an Excel sheet but with conditions:

For example:
If Cell in Column A="House" and Cell in Column B="Red" then rename Cell in Column B="Dark Red"

Do I do this with a macro? Please help. Thanks.

You probably don't need a macro
all you'd have to do is autofilter your data
filter column a for "equals" "house"
and then filter column b for "red"

then you can just replace the occurrences