Get instant live Excel expert help to learn how to combine conditional formatting with IF statement

Hi there need some help with conditional formatting please, using =AND(LEFT(K$4,4)="1350",K9>K34,K5<>"Buy") trying to make the cell not highlight red if buy is in row 5 but not working

I have 2 sheets containing data. The first sheet is a "map" with bin locations and the second sheet contains a list of products and which bin they belong to, but the locations are separated into 4 columns.("Aisle", "Rack", "Level" and "Bay." Ideally I'd like to see if there's a way to use conditional formatting to highlight a cell on the 1st sheet if the 4 conditions for a location on the second sheet are met. This is what I've tried so far that hasn't worked: =IFERROR(VLOOKUP(“6”,Inventory!A2:A1691,1,FALSE)+VLOOKUP(“3”1,Inventory!B2:B1691,2,FALSE)+VLOOKUP(“1”,Inventory!C2:C1691,3,FALSE)+VLOOKUP(“61.1”,Inventory!D2:D1691,4,FALSE),"false") =countif((Inventory!$K:$K=6),(Inventory!$L:$L=31), (Inventory!$M:$M=1), (Inventory!$N:$N=61.1)) Help?

Excel conditional formatting date. Need to have a cell change colors based on a date in another cell. If cell A2 has an date entered at 9/1/17 I want the current cell to turn red if today's date is 9/6/17 or greater.

For the midterm project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as descrbied in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II. CS302 Midterm Project Part I: Write a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. Preview your description with your instructor for approvail before proceeding to part II In your description include the following: 1. Who will use the workbook 2. Describe what the workbook will do (What purpose will it serve?) 3. Describe the type of data that will be stored in the workbook 4. Describe some of the analysis and reporting features of the workbook. Midterm Project Part II: Create the workbook to complete your project. Your workbook must implement the following technical requirements. 1. Well formatted with some background color, borders and style 2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field. 3. Apply appropriate named cell references to your workbook. 4. Implement goal seek analysis using absolute cell references and an assumption area. 5. Use conditional formatting on the database sheet. 6. Use two or more of the functions from this list: if(), iferror(), sumif(), countif() 7. Use a database lookup function like VLOOKUP() using a lookup table. 8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet. 9. Create some scenarios and generate a summary report. 10. Add at least one macro with a button to run the macro. 11. Use solver in some way. Be sure to create an answer report. 12. Add appropriate and consistant data validation fields 13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles. 14. Add an imbedded image with a link to a web web site. 15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password "MIDTERM". 16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option. 17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade. Submit your description document and project workbook for grading.

I would like to indicate at the top of a column with an icon, if there is conditional formatting in any of the cells below in that column. Further, can you change the icon based on the colour of the conditionally formatted cells?

Could someone help with a conditional formatting formula please. I have a worksheet where i would like a row to be highlighted depending on a couple of conditions. The sheet is K to Y in M is the leave date of the staff member then in Q there is a drop down list containing 3 options Deleted, Proxy for 1 month and Proxy for 3 months If the option Proxy for 1 month is selected then i would like the row highlighted when the date in M is one month old If the option Proxy for 3 months is selected the i would like the row highlighted when the date in M is three months old. If deleted is selected then do nothing. Just cannot get the date thing!

Hi there I want some help with conditional formatting. Basically the spreadsheet shows values/spread changes of bonds over time. In columns Z-AT I have calculated the various curves. I want to highlight with a darker green colour where the current curve (is column z the current 3s/5s curve) is less than the mom and ytd and use red for when its less then just to show how curves have moved to give us ideas in from a name specific basis if it makes sense to sell the longer dated and buy the shorter dated.

Making a dynamic gantt chart using conditional formatting, IF statements, WEEKDAY function, drop down menus, etc. 1. COMBINE THESE FORMULA INTO A SINGLE NESTED IF STATEMENT. SO FAR I HAVE RUN INTO CIRCULAR CELL REFERENCE ISSUES SO I AM NOT SURE IT THIS IS POSSIBLE OR IF WE NEED TO FIND ANOTHER WAY. If (Start Date=Row Date, when true, fill in a value of 1, if false, no value. IF(E10=K9:DI9, 1,””) Search the row and insert a 1 on the correct starting date. This formula is correct. If(sum of K10:DI10<D10,1,””) Insert a 1 value until the total number of days is reached. This formula allows us to add in travel days for clients quickly by replacing a 1 value with an x. The formula automatically inserts a 1 value at the end of the plan for each “x” input. Does not count values of “” or x. This formula is correct. If Delivery Date=5, insert an “x” for WEEKDAY value of 7 and 1 (Do not make food on Friday and Saturday) If Delivery Date=6, insert an “x” for WEEKDAY value of 7 (Do not make food on Friday) If Delivery Date=7, no action required (Deliver meals 7 days per week) This formula needs to be written. Conditional formatting for table: 1 value = green font, green background, complete x value = grey font, grey background, This conditional formatting is set. 2. DYNAMIC END DATE Use a formula to look up the last value of 1 in the row K10:DI10 and return the date from K9:DI9. This value will be shown in cell F10 In cell F10, =find the final 1 value in row K10:DI10 and return value from K9:DI9. This allows us to automatically update the end of plan to inform clients when their renewal is due. This formula needs to be written. 3. SET THE PROJECT START AND END DATE IN CELLS C5 AND C6 TO AUTO FILL THE CALENDAR DATES.

Making a dynamic gantt chart using conditional formatting, IF statements, WEEKDAY function, drop down menus, etc.

I am truly a beginner in Excel and need all the help I can get! Okay so I have a table that is $A$2:$N$333 and I would like column A to show a data bar to reflect the data that each row has completed. Example: Row 3 has data in every column up to G now I'd like Cell A3 to show a 50% data bar in that cell to show that only 50% of the data needed for that row has been entered. Is that possible and how would I go about doing so? (this is the reply I revieved from tech support) If you add another column for the data bar, you can do it with conditional formatting. If you insert a column before column A and inserted this formula: =COUNTA(B5:O5)/14 And then use conditional formatting in the cells in column A (open) conditional formatting Use: format all cells based on their values Choose data bar from drop down check box to show data bar only (in type) choose number from drop down Enter 0 on minimum and 1 on max Use solid fill and no border and hit okay I COULDN'T COPY AND PASTE THE IMAGE SO I DESCRIBED IT AS BEST AS POSSIBLE (This is my reply ) So after I've entered the formula into each cell down column A do I high light all of column A and then select the conditional formatting with Data bar? So I did Just that I copied the formula into each cell in column a and then I highlighted the column and did the conditional formatting using Data bars and I got nothing. In the picture it says edit formatting rule. I made a new rule with all of column A highlighted was I supposed to go through the manage rules window instead of make a new and also in the picture it says minimum (Type) Number 0 and max Number 1 was I supposed to put that in as well? Thanks for all your help I'm sorry I am so new at this excel stuff AND THEN I RECEIVED THIS REPLY Yes, you need to have it look exactly like the image I posted for it to work, so you'll need the types to be numbers and values to be 0 and 1. OKAY SO THIS ONLY ANSWERED ONE OF MY QUESTIONS AND IT STILL ISN'T WORKING CAN YOU HELP ME? PLEASE THANKS FOR ALL YOUR HELP VINTA