question

GodfreyDaniel-5759 avatar image
0 Votes"
GodfreyDaniel-5759 asked emizhang-msft commented

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

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".
102658-screen-shot-2021-06-05-at-15004-pm.png
Pic attached.

Thanks!

-GD


office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @GodfreyDaniel-5759,
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.


0 Votes 0 ·
emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @GodfreyDaniel-5759,
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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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
-GD103145-redbubble.png


0 Votes 0 ·
redbubble.png (250.6 KiB)

Hi @GodfreyDaniel-5759,
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","")

0 Votes 0 ·
GodfreyDaniel-5759 avatar image
0 Votes"
GodfreyDaniel-5759 answered

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"?103435-redbubble2.png



redbubble2.png (217.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GodfreyDaniel-5759 avatar image
0 Votes"
GodfreyDaniel-5759 answered emizhang-msft commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.


0 Votes 0 ·