+ Reply to Thread
Results 1 to 2 of 2

Conditional Format to highlight cells in a range if any have an entry

  1. #1
    Registered User
    Join Date
    05-09-2017
    Location
    NC
    MS-Off Ver
    2013
    Posts
    98

    Conditional Format to highlight cells in a range if any have an entry

    Happy Holidays and thank you for taking the time.

    My mind is drawing a blank and I will continue to work on it while awaiting a reply because I know I've done it before but can't remember which of my sheet.

    What I am wanting to do is format cells A1:E1 if any of them have initials in them. I have operators who have weekly tasks so if they initial in B1 then A1:E1 will change to the format I want which happens to be black fill with white font in this case.

    Currently my mind is still on holiday.

    Thank you very much for taking the time.

  2. #2
    Registered User
    Join Date
    05-09-2017
    Location
    NC
    MS-Off Ver
    2013
    Posts
    98

    Re: Conditional Format to highlight cells in a range if any have an entry

    I figured it out, thank you.

+ 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: 10
    Last Post: 12-11-2016, 08:01 AM
  2. conditional format if range has more than one entry
    By Todd6262 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2016, 02:50 PM
  3. [SOLVED] conditional format to highlight values out of range
    By Excel_learner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2015, 10:34 PM
  4. Replies: 6
    Last Post: 06-29-2013, 03:56 PM
  5. Highlight Unlike Cells (Conditional Format)?
    By stuffleb in forum Excel General
    Replies: 3
    Last Post: 09-21-2011, 07:35 PM
  6. Conditional Format formula to Cells highlight.
    By johncena in forum Excel General
    Replies: 4
    Last Post: 03-23-2010, 04:09 AM
  7. Conditional Format:Entry looks to mult. ranges to highlight many cells
    By Mishka1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-30-2007, 07:24 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