Get instant live Excel expert help with conditional formatting

Select the range E2:E30 and create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sticker price. Be sure to select a Rule Type that will use a formula to determine which cells to format.

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?

i need to add cells based on conditional formatting of other cells

I am working on my budget sheet... I have a column A that has due date Column B amount due Column C amount paid I want to do a conditional formatting to highlight cells that are less than today ( <Today() ) AND when Amount paid < amount due

conditional formatting issue using the shading function with a formula

I need a conditional formatting formula that includes color highlights at 150 vehicle hour intervals (green, yellow & red). The spreadsheet covers the span of a month as we enter data on a daily basis. The cells are running totals of the day prior but when the interval of 150 is reached, we would like to see a color highlight indicator for action.

how do i build a conditional formatting rule that highlights the cell if the cell is not empty or a reference cell contains "-P"?

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!!

Thank you again for the exceptional service in allowing me to continue my session as well as granting an additional session for free! To continue, please know the spreadsheet as provoided included the 150 intervals but we would like to have the values in each cell build on a daily basis, as opposed to restarting at every 150 interval. The conditional formatting (green, yellow & red) should go into action when the cell value has increased by 150 vehicle hours.

I'm trying to understand the conditional formatting associated with an Excel template