+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting - rule

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Conditional formatting - rule

    Hi

    I need some help with some conditional formatting pelase.

    In cells:
    X39, X41, X43,X45 and X47

    I would like a formula which will turn the cell yell if X24 = “New” until text is entered in the cell. E.g. if X24 is new and the cells are blank it would be yell. Once text is entered it will go white.

    Can anyone help please?
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Conditional formatting - rule

    Use conditional formatting formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Apply to range
    Please Login or Register  to view this content.
    Format to suit.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. conditional formatting rule
    By pphg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2016, 09:20 AM
  2. conditional formatting rule
    By claralou in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2016, 08:03 AM
  3. Conditional Formatting Rule if x is y and
    By nwpassage in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2015, 12:18 PM
  4. Conditional Formatting copies rule for each row
    By Amanda, in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2014, 08:59 AM
  5. Conditional Formatting By Rule
    By pickslides in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2014, 12:44 AM
  6. Conditional formatting rule need help
    By Kagesen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2011, 04:42 AM
  7. Replies: 1
    Last Post: 07-29-2010, 11:26 AM

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