+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting

  1. #1
    Registered User
    Join Date
    03-14-2019
    Location
    Glasgow, Scotland
    MS-Off Ver
    MS Office 2016
    Posts
    1

    Conditional Formatting

    I am having trouble with conditional formatting, with the issue explored in other threads but no directly applicable solution currently available.

    In Excel I create a blanket of conditional formatting to 'white-out' cells, including border. When I do this by clicking 'None' in Border Presets, followed by 'OK' 'OK' 'Apply', The cells are completely 'whited-out'. However, when I go to a different sheet and then return, the conditional formatting for the border stops working.

    I can get round this issue by selecting a Border in Presets and making the colour white, but I don't understand why the option of having no border selected will work momentarily and then cease.

    Any assistance in understanding this quaint excel feature would be appreciated.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Conditional Formatting

    It's just a little quirk!
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

+ 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] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 PM

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