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

1) I'm trying to use conditional formatting to highlight the lowest value in column D if the value in column C = "yes" and only if there are no other instances of that value. For example, if the lowest value in column D is 3 and the value in column C = yes but there is another instance of a 3 in column D and a "yes" in column C, then no cells should be highlighted. I have a conditional formatting formula built that is highlighting the lowest value in column D but doesn't take into account that the value in column C must = "yes". 2) If step 1 above is possible, can the conditional format formula in column D then be copied to column E?

im trying to create a holiday planner for the year where I can have separate departments on it - if an individual in a department has a holiday booked then his/her colleagues cannot take the same date - I thought conditional formatting but I cannot figure a method out.

Automatticaly copy row from Sheet1 to another sheet if cell in certain column from Sheet1 has specific conditional formatting.

-In column L, calculate the overall average grade for each student’s chapter assignments and exam. The overall average grade is the average of the contents in columns D through J. In Row 14 for each chapter and exam, create an AVERAGEIF function to calculate the average grade for those students who actually received a grade other than 0. Format both Row 14 and Column L to show one decimal. -In column M, calculate the final grade using a nested IF statement using the guidelines below: ------------ -Use conditional formatting in the final grade cell using light red fill with dark red text for any student earning an F. RULES ARE DOWNLOADED

In column M, calculate the final grade using a nested IF statement using the guidelines below: A 93-100 B 85-92 C 77-84 D 70-77 F 69 and below Use conditional formatting if statement in the final grade cell using light red fill with dark red text for any student earning an F. Create a named range called Final for the range M4:M12. In the Distribution of Grades section, use the named range and a function to calculate the number of students who have earned each grade. Add a custom number format to the student number to insert SN- before the number in the cell.

Trying to write a formula in conditional formatting to highlight when column N had "Stock" entered into it and column R in not blank. Currently using AND(NOT(ISBLANK($R4))) To change colour when a date is entered in column R, which works fine. Trying to add $N4="STOCK" but have drawn a blank with IF, AND, OR which ever way I try to nest it. Help!!

I am experiencing a new glitch in excel that conditional formatting blank cells are registering as a 0 and will highlight, even if I include a format that says all blank cells have no formatting it still doesn't change. I have used the same conditional formatting previously and it does not do this.

I need an excel conditional formula that makes the cell go red if the date is over 180 days ago or orange between 90 & 179 days from the inputted date, I do not want to use the Today function as this throws it out every time I open the spreadsheet.

hi. i have a spreadsheet and i need to highlight data that appears in one workbook compared to another. i have used the match formula and conditional formatting however i need the opposite of this, where if the data is not the same it must be green for example. Please help

I hope I explain this correctly C5 = todays date Column M = Has this formula =IF(I2="","",I2-C$5) it calculates the difference in days from a random date + it also has conditional formatting. Column I = The Random date Column F = Conditional formatting if M<8 its red and if M is between 30 and 8 and its yellow(same for column M) It works fine. I would like to have a button that will add a blank row below the row I’m working in and input the formula and conditional formatting accordingly. I have tried to record a macro and searched for advise but have had no luck. I hope you can help.