Excel Macro to change a name if certain condition is met

[sap1958]

I have a name in certain rows in a cell C called "Backlog". If the name is Backlog I want to change it to the word "Speculative". I know I could just sort the field manually and change the name however is there a simple macro that can change the text in cell C to "Speculative" if the field name in the row is "Backlog".

 

[randy700]

I'm confused.
Why not simply use Find and Replace?


Randy

 

[AnotherHiggins]

What Randy said.

Shortcut to Find and Replace: [Ctrl]+[H]

Just select Column C first if you need to limit the replacements to only that column.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

hi,

Not sure really what you intend, but is this what you want...
[tt]
=IF(C2="Backlog","Speculative","")
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}