Get instant expert help with Excel and Google Sheets

Trying to conditional format a range of cells in a column based on a separate column that are in the equivalent row

How does changing the power (cell F9) affect the true positives? Even if the test detected everyone with MCI (power=1) would there still be a problem?

I need to build a spread sheet that pulls data from two others sheets. What I'm hoping to do is when i type in a date in the new sheet, and that date matches a date in page 2 with a condition met in another column (ie: By typing in June 1rst, i want the sheet to identify, based on data in the next sheet, when if June first is cloudy or rainy). Can this be done?

Choose only one item from each category and sum cost for highest possible calories without going over max budget.

Have to pull budget number from one worksheet into another worksheet so if it is October then go to a separate Total Budget worksheet column 'October' cell Total Oct' budget number to insert on Interior Budget page. I think that is an IF-THEN statement. =IF 'Total Budget'!=Oct THEN A25 But I need to do that formula for the full year.

Hi, I have a sheet which is using VLOOKUP to get data from a salary field linked by an ID number which is on another sheet associated with the salary The problem I have is that we have multiple entries (rows) which have the same ID field so we essentially only have one row which displays the salary linked to the ID number but the others don't fetch the salary. What I want to do is have a formula which is basically 'IF the ID number matches the ID number of the row with the salary field filled in THEN copy the same salary to the empty fields on the other rows. To visualize: ID | Salary (fetched by VLOOKUP from ID) 1 | £100 2 | £110 3 | £105 3 | 3 | 4 | £120 5 | £150 As above the VLOOKUP doesn't fetch if the ID is the same (as the other sheet has only one instance of the ID) So I was wondering how to get excel to display the right number (£105) in the blank spots Thanks in advance

i want to paint lines in my excel sheet a specific color based on the date. will excel continuously track the date and time without input from me as long as he page is kept open? if so what formula would i use and what formula would i use for the painting

Need help appending text to a cell and converting it to a hyperlink.

Can you please tell me how to get unique id of my choice for the duplicate values.

I want cell E3 on the main sheet to populate date based on the drop down of cell A3 and the description I have given in cell B3 using data from another sheet. The other sheet has the value for the description of A3 & B3 in columns B-G. Can this be done?