Results 1 to 6 of 6

Conditional Formatting for entire row based on ranges of number in column F

Threaded View

  1. #5
    Registered User
    Join Date
    03-26-2020
    Location
    Connecticut
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    3

    Re: Conditional Formatting for entire row based on ranges of number in column F

    I have another issue with conditional formatting in my excel report. I realized after posting on this thread and getting a response that solved the report to, I now realize, a point.

    There are two conditions I need to meet that involves Column F, Days Until Due and Column E, Ball In Court...

    Where John Smith's name shows up in Column E, whether singly or with other names present (i.e. cell rows 2, 3, 4, 6) and the Column F numbers are 1 or greater, the whole cell row needs to be green.

    Where names other than John Smith's appear and the Column F numbers are 1 or greater, the whole cell needs to have no fill.

    I've been pulling my hair out trying to configure the formula using AND, IF, THEN, etc. and could use some help here.

    FYI - The conditional formatting in these rows is back to it's simplest format.

    Thank you in advance!
    DCnyc

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting Entire Columns based on other column values.
    By Jephph1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2022, 11:36 PM
  2. Replies: 1
    Last Post: 08-11-2021, 09:53 AM
  3. [SOLVED] Need to repeat conditional formatting down an entire column forever based on formula?
    By IT_Padawan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2018, 10:19 AM
  4. Replies: 6
    Last Post: 07-02-2013, 10:29 AM
  5. [SOLVED] Conditional Formatting Entire Rows based on Change in Cell Value in Column A
    By Etain in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 09-26-2012, 07:31 AM
  6. Replies: 5
    Last Post: 05-03-2012, 06:06 PM
  7. Replies: 6
    Last Post: 02-16-2012, 04:52 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