+ Reply to Thread
Results 1 to 9 of 9

Conditional Formatting won't apply to Entire Range

  1. #1
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Conditional Formatting won't apply to Entire Range

    ok guys... seriously, what am i doing wrong that column O won't apply the conditional format ? it stops at row 190, but the cells in B191 & 192 are not blank, so column O should have borders around the cells all the way to row 191.

    and in excel 2003, column O CoMPLETELY ignores the conditional formatting. -_-*
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by NBVC; 05-11-2011 at 02:34 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Conditional Formatting won't apply to Entire Range

    Change the formula to =$B1<>""

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,175

    Re: Conditional Formatting won't apply to Entire Range

    Because you are starting your criteria with B3 and your range is O:O which starts with O1. So O1 is matched to B3, O2 to B4, etc. Change your range to $O$3:$O$20000 or something like that.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Re: Conditional Formatting won't apply to Entire Range

    Quote Originally Posted by brokenbiscuits View Post
    Change the formula to =$B1<>""
    B1 is empty. I only want it to format with a border if there's a name populated on it's row.

  5. #5
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Re: Conditional Formatting won't apply to Entire Range

    Quote Originally Posted by ChemistB View Post
    Because you are starting your criteria with B3 and your range is O:O which starts with O1. So O1 is matched to B3, O2 to B4, etc. Change your range to $O$3:$O$20000 or something like that.
    WOW... lol SO broken Buisquits was right, and my narrow-minded self didn't get it lol. Sorry Broken Bisquits! Thanks very much you two! lol

    so for future reference... If i want to start at B3 i'd have to apply the format to range O3:O65530 then? (For 2003)

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,175

    Re: Conditional Formatting won't apply to Entire Range

    Yes, that's correct.

  7. #7
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Re: Conditional Formatting won't apply to Entire Range

    why can't I close this thread? i dont have the "Edit" feature available under my first post .

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Conditional Formatting won't apply to Entire Range

    Because it is older than 2 days... I have closed it for you.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  9. #9
    Registered User
    Join Date
    04-16-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    25

    Re: Conditional Formatting won't apply to Entire Range

    Thank you ^_^!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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