+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting with "****"

  1. 09-25-2020, 11:31 AM #1
    andrewc
    andrewc is offline
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    812

    Conditional Formatting with "****"

    Hi,

    I have created a formula in conditional formatting to shade values that are >=0.01, <=-0.01 or equal to "****".

    It seems to work for the two value conditions but not for the "****".

    Can someone please suggest what I'm doing wrong.

    Thanks!
    Attached Files Attached Files
    Last edited by andrewc; 09-25-2020 at 12:47 PM.
    Reply With QuoteRegister To Reply
  2. 09-25-2020, 11:50 AM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Conditional Formatting with "****"

    Change the CF formula to

    =OR(A1 = "****", IF(ISNUMBER(A1), ROUND(ABS(A1), 2) >= 0.01))

    Otherwise, it evaluates to an error.
    Last edited by shg; 09-25-2020 at 12:44 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 09-25-2020, 12:47 PM #3
    andrewc
    andrewc is offline
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    812

    Re: Conditional Formatting with "****"

    Thanks very much
    Reply With QuoteRegister To Reply
  4. 09-25-2020, 03:55 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Conditional Formatting with "****"

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] "Remove Duplicates" not working despite "Conditional Formatting" finding the dupes
    By Vitae in forum Excel General
    Replies: 7
    Last Post: 10-21-2019, 03:34 PM
  2. Conditional Formatting: Excel not recognizing "1-" and "1+" as numbers.
    By ExcelGuySf in forum Excel General
    Replies: 6
    Last Post: 11-25-2018, 10:49 AM
  3. Conditional formatting by testing for "True" or "False"
    By Excel_vba in forum Excel General
    Replies: 2
    Last Post: 02-21-2014, 11:26 PM
  4. [SOLVED] Conditional formatting - formula if cell does NOT contain "," or "@"
    By Armitage2k in forum Excel General
    Replies: 12
    Last Post: 12-02-2012, 06:23 AM
  5. Conditional Formatting - Replace date with "YES" or "NO"
    By christinie in forum Excel General
    Replies: 3
    Last Post: 11-01-2012, 04:10 PM
  6. [SOLVED] Conditional formatting to highlight duplicates based on "Yes" or "No" in another column
    By BB1972 in forum Excel General
    Replies: 2
    Last Post: 08-17-2012, 05:10 AM
  7. [SOLVED] excel should "paste special" a "conditional formatting"
    By lozturk21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1