1. gravanoc

    Conditional Formatting contradicting formula

    Gee, my favorite topic! Conditional formatting is kicking my *** again. Problem Statement: My conditional formatting formula is applying formatting to the correct & incorrect cells, all except cells with vanilla text in them in column E. What is disquieting about this situation is that I have...
  2. B

    Simple Conditional Formats using VLOOKUP

    I can do complex spreadsheets but never seem to get the syntax right on conditional formats, especially when it includes a vlookup: Skipping straight to Manage Conditional Formats "IF" statement: 1. I need to say IF the value in A2 = (any value found in Array in Sheet2 column B) then format...
  3. V

    conditional formatting..

    In Col B, 10 21 35 15 50 16 I want to highlight top 3 in different color, using Cond do that?
  4. B

    Getting Error on Cond Form VBA - Unable to Bold

    Hello, I am getting an error with the code below. The error is "Unable to set the Bold Property of the Font class" Sub CFAHTNeg() Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=IF($M6=""Above"",TRUE,FALSE)"...
  5. M

    Counting Conditionally Formatted Cells

    Is there a way to count the value of a cell only if the cell is red? For example, if there is a column of cells that is all different colors, is there a way to only count the values in the red cells? Each of the different cells were conditionally formatted. mkfwaldron

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...