Closed Thread
Results 1 to 3 of 3

Conditional formatting button not working

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    Mississippi Gulf Coast
    MS-Off Ver
    2007
    Posts
    4

    Conditional formatting button not working

    Hi - My Conditional Formatting button stopped working (MacOS Mojave 10.14.2, Excel 2016 for Mac, V15.25). This is true for existing files with the formatting done previously and new files. None of them are in shared mode, and all are on my local drive (both hard drive and thumb drive). I made sure no groups of cells were selected on other tabs. Whenever I click the Conditional Formatting button, the only thing that happens is the three color window file control buttons (red, orange, and green at top left of screen) go gray. I saved to Excel 97-04, same issue.
    Any help appreciated.

  2. #2
    Registered User
    Join Date
    01-20-2016
    Location
    Mississippi Gulf Coast
    MS-Off Ver
    2007
    Posts
    4

    Re: Conditional formatting button not working

    I have to update this question/issue. The problem is actually affecting all ribbon commands. None of the commands, when clicked, give a drop down menu and the red/orange/green button go gray when a function is selected. This severely limits the app's use.
    Since this (by title) is significantly different than OP, I am going to open a new thread.
    Any suggestions appreciated.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,850

    Re: Conditional formatting button not working

    As it seems that this thread is now moot, I shall close it in favour of the one you are going to open.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Why is my conditional formatting not working?
    By liamfrancis2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2017, 11:16 AM
  2. [SOLVED] Conditional Formatting not working
    By tsummers46045 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-25-2017, 02:12 AM
  3. [SOLVED] Conditional formatting is not working.
    By opusarlo in forum Excel General
    Replies: 3
    Last Post: 05-08-2015, 10:39 AM
  4. Conditional Formatting not working.
    By EquityTrader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 12:50 PM
  5. [SOLVED] Conditional formatting not working
    By boomboomblock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2013, 06:27 AM
  6. Conditional Formatting is not working
    By rengrish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2012, 01:23 AM
  7. Conditional Formatting Not Working
    By mycon73 in forum Excel General
    Replies: 14
    Last Post: 07-16-2011, 01:39 PM

Tags for this Thread

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