+ Reply to Thread
Results 1 to 3 of 3

Using Conditional Formatting to change font style based on another cells value

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    Palatine, IL USA
    MS-Off Ver
    Excel 2016
    Posts
    34

    Using Conditional Formatting to change font style based on another cells value

    I am trying to use conditional formatting on a cell based on the value of another cell in the same row. I would like to conditional format the Font style based on this cell.

    Font style is not selectable though, even though the dialog box says you can use conditional formatting to change font style and other properties.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Using Conditional Formatting to change font style based on another cells value

    The dialogue box says "For Conditional Formattting, you can set Font Style, Underline, Color, and Strikethrough".

    Font Style = Regular, Italic, Bold, Bold Italic, and not the "Font".

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Using Conditional Formatting to change font style based on another cells value

    I agree with cbatrody. However, if you are allowed to use a Macro, a macro can do what you want. The macro implementation would depend on how the values are changed in your workbook (manually or by formula). If that's what you want to do, post a sample workbook with BEFORE and AFTER instructions.

    Lewis

+ 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: 6
    Last Post: 07-18-2013, 04:16 AM
  2. How to using comma style without change font & font size
    By rameshtupe in forum Excel General
    Replies: 1
    Last Post: 07-11-2013, 01:19 PM
  3. Replies: 6
    Last Post: 03-20-2012, 12:08 AM
  4. change font color and font style in shape
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2011, 10:05 AM
  5. Font Style - Conditional Formatting
    By Edsaid in forum Excel General
    Replies: 3
    Last Post: 10-06-2010, 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