+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Rules

  1. #1
    Registered User
    Join Date
    07-24-2017
    Location
    Surrey, England
    MS-Off Ver
    2010
    Posts
    8

    Conditional Formatting Rules

    Hi All,

    I am wondering if its possible to do the following

    For Example

    If Cell O25 = 1 THEN BOLD CELL J25 AND L25?

    I also have 30 sheets in my workbook if there is a way to apply the function to all sheets in one go

    Thanks

    Lee

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Conditional Formatting Rules

    Yes. You would need two rules in this case: one for J25 and one for L25. For the format equation you would just have
    =O25=1

    As for applying across worksheets, that is something Excel used to be able to do, but is no longer allowed. Don't know why. Using format painter across each sheet seems to be the fastest method.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Conditional Formatting Rules

    One formula will do. Select J25, then with J25 selected, Ctrl+select L25 then apply the formula: =$O$25=1

    Notice that the refers to range is: =$J$25,$L$25
    Ben Van Johnson

+ 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 with more than 15 rules
    By lnjkbsn in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-26-2016, 05:01 AM
  2. [SOLVED] Conditional Formatting - 2 rules in 1
    By Leathermyth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 02:29 PM
  3. Conditional Formatting two rules
    By pauldaddyadams in forum Excel General
    Replies: 1
    Last Post: 11-21-2014, 11:15 AM
  4. [SOLVED] Conditional Formatting Rules
    By GoGoeGo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2014, 01:48 PM
  5. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  6. What new rules do I need for Conditional Formatting?
    By ypurcaro in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-12-2013, 04:30 AM
  7. [SOLVED] Conditional Formatting Rules Help
    By PCAg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2012, 05:33 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