+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting not changing font colour as required

  1. #1
    Registered User
    Join Date
    02-02-2006
    Location
    Sydney . Australia
    MS-Off Ver
    2007 and 2013
    Posts
    98

    Conditional Formatting not changing font colour as required

    Hi there,
    If a cell cntent includes a symbol [as an arrow, for instance] beside the text,the font colour does not change as required when the condition is met.
    Please see the attached sample.
    Thanks in advance.
    Attached Files Attached Files
    Last edited by Michael6; 10-03-2009 at 05:02 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Conditional Formatting not changing font colour as required

    For some reason some of the cells have partial formatting.
    Select the range and set the Font colour to automatic. CF should now work as expected.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-02-2006
    Location
    Sydney . Australia
    MS-Off Ver
    2007 and 2013
    Posts
    98

    Re: Conditional Formatting not changing font colour as required

    Andy Pope,
    You are quite right; your answer saved me a lot of trouble trying to figure out what the hell might be the couse of the problem. Thank you very much.
    The problem is now solved
    Last edited by Michael6; 10-03-2009 at 05:04 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1