Highlight if Cell contains asterisk(*)

  • Conditional formatting - Highlight cells rules - Text that contains, then enter ~* in the box and choose your formatting.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Do you mean highlighting individual characters, or highlighting cells that contain any characters in a list?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Assuming you have the special characters in range E1:E10 (you can adjust as necessary) and that you are applying this to a range starting with cell A1, use:


    =SUM(COUNTIF($A1,"*"&$E$1:$E$10&"*"))>0


    If you are using the wildcard characters * ? or ~ in your list, enter them as ~* ~? and ~~ in the relevant cells.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why