+ Reply to Thread
Results 1 to 6 of 6

Using Cell Style Formats in Conditional Formatting

  1. #1
    Registered User
    Join Date
    12-02-2009
    Location
    Sheffield, England
    MS-Off Ver
    Office 365
    Posts
    22

    Using Cell Style Formats in Conditional Formatting

    Hi All

    I'd like to use the Cell Style format for 'Bad' (i.e. light red fill and dark red text) in a conditional formatting rule.
    I'm sure there's a way to pick these, but I can't seem to find it. Where should I be looking?

    TIA

    Si

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,031

    Re: Using Cell Style Formats in Conditional Formatting

    Not that I know of (there's no reference to styles in the CF dialog) - but of course you can replicate them easily enough.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    12-02-2009
    Location
    Sheffield, England
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Using Cell Style Formats in Conditional Formatting

    I should add - this is using a formula to determine which cells to format, not using one of the built-in rules (e.g. greater than, less than etc).

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,031

    Re: Using Cell Style Formats in Conditional Formatting

    Reply is the same, though - see post #2.

  5. #5
    Registered User
    Join Date
    12-02-2009
    Location
    Sheffield, England
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Using Cell Style Formats in Conditional Formatting

    Quote Originally Posted by AliGW View Post
    Not that I know of (there's no reference to styles in the CF dialog) - but of course you can replicate them easily enough.
    Thank you. Tried to add rep but I need to give to someone else first

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,031

    Re: Using Cell Style Formats in Conditional Formatting

    No worries. For what it's worth, the CF dialog is long overdue an overhaul in my view.

    Please mark as solved.

+ 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 to change the style of the cell
    By hanif in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-25-2017, 10:05 AM
  2. Formatting a Cell with conditional formats and a formula
    By wysbob in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2015, 09:50 AM
  3. Conditional Formatting/Traffic LX style is not formatting correctly
    By christinembater in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 12:32 AM
  4. [SOLVED] Conditional formatting: Copying styles and formula, but with different cell references
    By tays01s in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-26-2013, 02:34 AM
  5. Font Style - Conditional Formatting
    By Edsaid in forum Excel General
    Replies: 3
    Last Post: 10-06-2010, 05:42 PM
  6. True/False Conditional Formatting Icon Style
    By chasepes in forum Excel General
    Replies: 3
    Last Post: 07-07-2010, 11:18 AM
  7. Conditional Formatting with Style
    By TKrepitch@aol.com in forum Excel General
    Replies: 0
    Last Post: 06-06-2006, 01:45 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