+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting, stuck, I'm almost there, just need the final piece

  1. #1
    Registered User
    Join Date
    05-22-2022
    Location
    Texas City, TX
    MS-Off Ver
    2016
    Posts
    30

    Conditional Formatting, stuck, I'm almost there, just need the final piece

    I have a worksheet where cells V8 to V23 are required entries with a Y or N (I have the required part done for this range)
    If any of those cells have a N entered, then K33 MUST be filled out.
    I have figured out if V8 is N, then K33 must be filled out, that part works

    I'm stuck at the entire range of V8 to V23

    Here's what I have entered in the Conditional Format area (the part that works)
    =AND(V8="N",K33="") the K33 cell turns red, indicating it must be filled in

    My question is how to set the range for V8 to V23, I tried V8:V23, without success.

    Thanks

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,827

    Re: Conditional Formatting, stuck, I'm almost there, just need the final piece

    In cell K33, under conditional formatting, try this:

    =AND(COUNTIF(V8:V23,"N")>0,K33="")

  3. #3
    Registered User
    Join Date
    05-22-2022
    Location
    Texas City, TX
    MS-Off Ver
    2016
    Posts
    30

    Re: Conditional Formatting, stuck, I'm almost there, just need the final piece

    Thanks Gregb11, success, it works like a charm.

+ 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. Formatting a piece of the text in the formula box
    By Ronnet2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2016, 12:25 PM
  2. [SOLVED] Conditional formatting Stuck in Range
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2015, 09:29 AM
  3. How to display output from one locked data piece and one client-input data piece?
    By tnovak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 12:48 PM
  4. Conditional formatting stuck
    By M1234 in forum Excel General
    Replies: 12
    Last Post: 10-01-2013, 09:05 AM
  5. Stuck and Need to Loop a Particular Piece of My Code
    By Monkey Brain in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-08-2013, 03:48 PM
  6. [SOLVED] Conditional Formatting versus macro code inthis example -stuck how to solve myself
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2012, 08:11 PM
  7. replacing lowest test grade with final if final is higher formula help
    By colbyclay in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2012, 02:48 AM

Tags for this Thread

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