+ Reply to Thread
Results 1 to 2 of 2

Is it possible to scale font color?

  1. #1
    Registered User
    Join Date
    02-15-2018
    Location
    Brighton, England
    MS-Off Ver
    Microsoft Excel 2019 MSO (16.0.13628.20128) 32-bit
    Posts
    23

    Is it possible to scale font color?

    Hi,

    Using conditional formatting, is it possible to scale the font color instead of the cell color?
    And if so how?

    Thanks.

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

    Re: Is it possible to scale font color?

    The built in CF will only do fill colour.

    You can use VBA to replicate.
    The example applies 3 colour scale Red>Yellow>Green

    It uses the Change event to trigger the refresh.

    worksheet code
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    If you want a different CF style then just record the application of the CF and modify the above code.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 3
    Last Post: 10-18-2020, 09:15 PM
  2. [SOLVED] Conditional Formatting like Color Scale but doing it via Interior.Color
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 06:36 AM
  3. Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  4. Replies: 16
    Last Post: 11-21-2012, 07:20 PM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  6. Setting the X axis scale/font
    By CLR in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-13-2005, 05:06 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