+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting withouth data visible

  1. #1
    Registered User
    Join Date
    06-28-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    7

    Conditional Formatting withouth data visible

    Good Morning All,

    I have a quick question on formatting a data image/set as follows:
    PMIs.PNG

    I want to replicate this image with my datasets, essentially want to have the change in data for different countries reflect on if its getting better or worse.

    However, I notice the colour scheme changes marginally but there is no data show.

    How do I do this?

    Thanks & chat soon.

  2. #2
    Registered User
    Join Date
    06-28-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    7

    Re: Conditional Formatting withouth data visible

    Thanks all figured it out.
    Data, Custom and then ;;; to make data invisible.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Conditional Formatting withouth data visible

    Nice, thanks for sharing your solution
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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 - every Nth visible column
    By khaliera in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2017, 10:26 AM
  2. Conditional formatting of visible cells Excel 2010
    By cmikec in forum Excel General
    Replies: 4
    Last Post: 05-11-2017, 03:07 PM
  3. Mail only visible cells with conditional formatting
    By Protonspounge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2017, 11:14 AM
  4. Copy only visible columns with conditional Formatting
    By Protonspounge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2017, 04:54 AM
  5. Use conditional formatting only on visible not hidden cells
    By JackBauer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 08:26 AM
  6. Conditional formatting: Applied rules not visible when printing
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2013, 03:32 PM
  7. [SOLVED] Conditional Formatting Shading For Visible Rows Only
    By manda in forum Excel General
    Replies: 3
    Last Post: 05-22-2006, 05:42 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