Excel formatting - how to change a cell value based on another's

Question

Excel formatting - how to change a cell value based on another's

Godfrey_Daniel 1

Greetings all,

I'm doing some personal finance tracking. When I download a .csv of my transactions, sometimes it categorizes things too broadly.

Example: I only use Redbubble to buy tee shirts, but it's categorized as "Hobbies". I need a conditional formatting rule to say:

"If 'Redbubble' appears in column B change the text value (in the same row) of column F to "Clothing".

Pic attached.

Thanks!

-GD

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-06-15T01:58:52.837+00:00

Hi @Godfrey_Daniel ,
I am just writing to see if you have any updates about this problem. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

3 answers

Your answer

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-06-15T01:58:52.837+00:00

Hi @Godfrey_Daniel ,
I am just writing to see if you have any updates about this problem. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

Hi @Godfrey_Daniel ,
Do you only have one condition in Column F?
If yes, you can enter the formula in Column F:

=IF(B1="Redbubble","Clothing","")

If my understanding is incorrect, please provide more information about your problem or you can upload a screenshot so that I can get more accurate solutions to this problem. I'm glad to help you.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Godfrey_Daniel 1 Reputation point

2021-06-07T22:56:43.9+00:00

Thanks so much. Yes, I only need that one condition.

I tried that function, but it makes the cell blank (even if I click away from it). Here's a screenshot.

Thanks
-GD
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-06-08T06:05:49.877+00:00

Hi @Godfrey_Daniel ,
Do the formula need to apply for the all cells in Column F? How can I return other results? For example Gift, Groceries?
And the formula in your picture, you need to change the B1 to B84:

=IF(B84="Redbubble","Clothing","")

Answer 2

Godfrey_Daniel 1

Great. After I changed it to B84 it changed the cell to "clothing". But how do I write the formula so that if ANY cell in column B is "Redbubble" change to "Clothing"?

Answer 3

Godfrey_Daniel 1

Actually, this might be easier. Is there a way to use a function that applies to the entire spreadsheet that does this?

If any cell ="Hobbies" change it to "Clothing"

-GD

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-06-10T08:56:50.237+00:00

You can use Replace feature in Excel:

https://www.youtube.com/watch?v=hmizmgOjNYo

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Share via

Excel formatting - how to change a cell value based on another's

3 answers

Your answer