Hi there! My name is XXXXX XXXXX I will be assisting you with you question today!
First, select cell A1 as described and click on Conditional Formatting on the Home tab of excel
Select "New Rule:
Then select "Use a formula..." for the Rule Type
In the formula bar field use the following:
Then select a format (so Fill, select a red color)
That should make A1 fill the background red if "red" is contained anywhere in the B1:B100 range of cells
Let me know if that works for you
Here is a link to an example that I have created for you: http://www.ge.tt/2T28cVl/v/0?c
If you run into any issues please let me know and I will gladly further assist you
Great, thanks for the update Jose.
Here is the function that you will need to use: =COUNT(SEARCH("Red",$B$1:$B$100))
Thanks for your patience and sorry for the technical difficulties. The Live Chat response should have been saved to this conversation after the chat was switched to a Q&A session.
Here is the example .xlsx file that I created to meet your request: http://sharesend.com/eoofh1jp
Let me know if that helps!
If it does please take a moment to rate our interaction to close this question.
If you have further questions, please feel free to ask them below and I will gladly continue to assist you!
Hi Dan, You were very helpful with my last question, I hope you can help me with this one.
I have the following sheet in workbook:
in sheets "jan", "feb", "mar" I have long list of expenses in column A. In column B, I have the I have names of expense categories.
I want to add the expenses by category.
I know how to do it for each month.
For example in F1 I had the text "office", that is one of the categories, G1 I wanted the total for category "office", so I did the following formula:
=Sumif('jan'!B1:B100,F1'jan'!A1:A100) and it worked fine.
However, I want the totals in the sheet "year" I want the range to include B1:B100 from sheets jan, feb, and mar.
How do I do it?
I already tried:
=Sumif('jan'!C1:100+'feb'!C1:100,F1,'jan!'B1:B100+'feb'!B1:B100) and it didn't work.