## Highlighting all rows that have values within a specific column that match any of the cells of another column

I am struggling to create a conditional format formula that highlights the following; – Highlight any rows of the cells within Column B …

I am struggling to create a conditional format formula that highlights the following; – Highlight any rows of the cells within Column B …

I have a list of 20 checks. I am looking for 8 that equal $1128.25. Is there a formula applied to the 20 to find which 8 give me my total? Thank you for your …

I am trying to create a formula which will find all of the students in a particular program by subject code. My formula works if there is just one …

Could someone break this formula piece by piece and explain how it works to me? it works appropriately in my file, but I am unsure how exactly it works. …

find the bonus.if sales greater than or equal to 500000,bonus is 0.5% on sales, otherwise enter zero. By: OSHADHI DE

Hi, Please I want to know the formula if the rersponse received within 12 calnder days to give check mark And if more that 12 calender days to give X as …

Hello, i know there must be a simple solution to this but cant figure it out atm. I have a table that i added to data model and then take out graphs from. The …

How do i Express the following multiple conditions in 1 formula IF A1=10 and B1=15 then C1=Apple Else C1= Orange IF A1=20 and B1=25 then C1=Tomato Else C1= …

Hi Everyone, I have two drop down one will have the values of all month that is from January to December other one is dependent dropdown will have values of …

An API returned the following result: { “Global Quote”: { “01. …

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook. I’m getting an error in my code on the last line …

I want to have the date auto fill in column G when the word “Complete” is in column F and want it to stay that date. How do i do that or can that …

I am trying to create a spreadsheet that will total the number of hours spent in work during each month and give me the monthly average based on the number of …

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

Hello: I am trying to create a formula that will search two columns of data. Each column is on a separate sheet within the same workbook. If …

RIght now I have a workbook that has a masterlist of data that updates another worksheet for the first quarter. We need to create a third worksheet for …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’ve got 2 sheets with common column A. If the cells in column A of sheet 2 match that in sheet 1, I want to copy the data from sheet 2 columns B-J …

I need a formula to count distinct IDs based on category and the date the category was added is less than 30 days Data structure: Column F – …

Current formula i am using: …

A company works out the monthly pay for sales staff using the equation y = ___x 10 + 600, where y is the monthly wage (£) and x is the …

applied a formula in a cell and the result is 0.2. Used this value in another cell in Index & match formula but the formula is taking 0.2 as …

i have about 1000 emails Ids in word. i have copied from word to Doc. and all emails copied to 1 row example: abc@gmail.com abc@hotmail.com …

I need to know when various symbols can appear in Excel (Conditional Formatting) Formulas, and when a letter character followed by a number character can …

I need a formula to look if a value from a cell exist in a array of data and print “name 1” if it was found, if not search another array, if found …

Hi, Lets say that I can export from a system this set of data: Student Number Student Name Class Fruit Quantity 1234 Tom 2A Orange 0 …

what will be the formula for calculating if an employees work from 09:00 am to 07:00pm per day will be paid rs750/-, and after 07:00pm until 06:00 am will be …

Sheet 1 A B 1 Apple 10 2 Pear 8 3 Orange 3 Sheet 2 A B 1 Apple 7 2 Orange 3 3 Durain 1 Sheet 3 A B 1 Orange 4 2 Pear 6 3 Banana 5 Sheet 4 …

Hello, I’m a learning to trade the stock market. There is a rule called Pattern Day Trading (PDT). This rule says in a rolling 5 day period …

I’m trying to link most of the data from one workbook into another, and the methods I’ve been googling aren’t working. If I try to …

I am trying to see if Excel can do this: I have a budget spreadsheet with items I have budgeted for with 4 columns that represent each week of a month. In …

i would like to create a sheet for calculating overtime workers that work on field. calculating the hours for 2 different dates is fine but separating it …

In Excel I have a list of criteria over 4 columns. In another sheet I wish to lookup that all four aspects match, but where blank I would like to find …

=VLOOKUP(1,’Main Tracker’!A:F,6,FALSE) When I copy this formula down, I want the lookup_value, the “1”, to fill series so when I …

I am having trouble figuring out the IF formula for when a cell number that the user inputs increases by 1000 another cell increases by 1. For example if 8000m …

i have a spreadsheet for a sports team. i have the formula for scores example. A2 = 13, B2 = …

I want to subtract two cells in excel but only if both cells have a value. More exactly in this case C1 is currently =SUM(A1-B1), where A1 is my selling price …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.