Get instant live Excel expert help with conditional formatting

I am looking for google sheet conditional formatting custom formula! What I would like to do is highlight the lowest cost in my range cells from U7 to BV311 and have it equal to lowest quoted price in row Q in one action. However, I am forced to go line by line with the conditional formatting : Highlighted Cell Rules --> Equal to --> =$Q$56 with (Custom format). Can you please help me to streamline this process? I have 250 more lines to go!

I need help to transfer google sheets conditional formatting based on another cell text of cells to drop down boxes on a different sheet

I'm trying to create a shading formula to find prerequisites. If E2 contains "IT-420", and cell F2 contains at least "IT-489", then E2 should be shaded yellow I try this formula in cell, and it works, but when I go to use a conditional formatting formula, it doesnt. ="IF(AND((E2>=""IT-420""),(F2>=""IT-489"")))"

I'm using the excel conditional formatting if wherein I want to highlight certain cells with the following conditions: Highlight if A4 is >=1 and B4 is >=1 and E4 is >=2 and F4 is >=3, OR if D4 is >=5 and E4 is >=2, F4 is >=3 How do I do this using the conditional formatting?

I am having a challenge with conditional formatting. My workbook has 2 sheets (SheetA, SheetB). When data is entered into some cells in SheetA, it automatically fills to the appropriate cell in Sheet B (=SheetA!cell #). This is working fine. The challenge I am having is the data in SheetA is formatted (date, number, etc.). When cells in SheetA are blank because data has not been input yet, there are 0's or incorrect dates in SheetB. What I want is to conditionally format the cells in SheetB to be blank unless data has been input into the reference cell in SheetA. Thank you for the help.

Conditional formatting - I'm trying to change the format of a cell based on the value in another cell. I have a table with 100+ lines; when column E reads "complete," I want column C to go back to plain format

Is there an actual function that changes cell colour rather than Conditional Formatting? It wouldn't work in this situation. I basically have an IF statement and I want the TRUE result to be the colour of the cell changing. Ive tried setting it to "1", then setting a rule where all "1" become that colour, but nothing happens. I've tried it with and without the quotations.

Hey! So I'm trying to highlight data in Column D that is next to highlighted data in Column E. Is there any way​ I can make an excel conditional formatting rule for this?

I need a formula to find similarities in one column of excel data (12,000 rows) that would clearly indicate the cells that are extremely similar to another cell, even if not a direct match. I tried fuzzylookup and that would not work as well as the excel conditional formatting row rules.

0%(-26%) how can i put conditional formatting considering values in bracket eg. i want to put red if bracket value is negative despite whatever is 1st value