+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Problems

  1. #1
    Registered User
    Join Date
    Toronto, ON
    MS-Off Ver
    MS Office 2010

    Conditional Formatting Problems

    I got a strange one here: I have a file that has several formulas, links and conditional formatting in it. I made a copy of that file, saved it with another name and everything works in the file except the conditional formatting. I have simple conditions (if cell = 1, change the fill color to blue, = 2 change fill to red, etc.) and they are no longer working. I even tried to delete and re-do the formatting and they don't work. Any ideas why or how to correct this?

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows

    Re: Conditional Formatting Problems

    can you post an example spreadsheet

    any chance the numbers are actually formatted as text ?
    or are you testing as text rather than numbers

    "1" = text test

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting problems
    By Ztv in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2014, 05:08 AM
  2. Conditional formatting problems
    By swexl in forum Excel General
    Replies: 6
    Last Post: 01-09-2014, 01:11 PM
  3. [SOLVED] Conditional Formatting Problems
    By gideonbot in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2008, 07:09 AM
  4. Problems with Conditional Formatting
    By Jaymond Flurrie in forum Excel General
    Replies: 0
    Last Post: 10-11-2007, 02:05 PM
  5. Problems with Conditional Formatting
    By Niall in forum Excel General
    Replies: 2
    Last Post: 08-22-2006, 04:45 PM

Tags for this Thread


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