The example formula used for 2 conditions was helpful for me. I had no idea what was wrong but the required formula was simple and didn't need IF or true/false components.
Thanks Jeff! I totally got stuck on this exact problem and didn't know the value function would work. Looking up zip codes with an apostrophe in front of it would hopefully work for next time.
No need to edit a query to change the data source. In Excel go to Data -> Get Data -> Data Source Settings... and change it there. Also to select all columns in Power Query, select one column and then hit [Ctrl]A.
That was a great video. Do you know if the excel has some formula using a change the color of the text or number? For example, if you use Xlookup formula, when you bring the text or number and, in this formula, use other formula to change the color. Thank you.
How do you compare two columns? I have searched and searched. I have two columns of numbers and want to have one cell at the top that simply will tell me if ANY records in column A exist in Column B.
Very useful and easy to follow. I have a question: what if instead of “open” in that cell I have a date? How do I tell the conditional formatting that the row needs to be highlighted as long as in the C7 column there is date? I need this as I share a doc and colleagues will go in and complete tasks, once they complete the task they enter the date in which they completed and I want to see immediately when this happens by having the rows filled in. Thanks
Please go slower in your teaching. You move too fast. Also if you could provide a copy of your worksheet/folder to us that we can download so we can do the steps with you, that would be helpful.