+ Reply to Thread
Results 1 to 8 of 8

Conditional Formatting with Named Ranges

  1. #1
    Registered User
    Join Date
    03-09-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    14

    Conditional Formatting with Named Ranges

    Hello

    Ok so i have a range of cells (B2:B6) to be colored and if possible locked for editing when a value in A1 is selected.The catch here is A1 is a dropdown defined with a name range "XYZ" and values of X1,X2,X3. I cant get it to work with conditional formatting.I Ve selected the cells (B2:B6),Format->Conditional Formatting-> Formula is $A1=X1.This did not seem to have any effect.

    Pls help

    Regards
    Revverend

  2. #2
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Conditional Formatting with Named Ranges

    Your X1 is refering to a cell location, change it to $A1="X1" to match a Text string

  3. #3
    Forum Contributor
    Join Date
    09-23-2008
    Location
    UK
    Posts
    137

    Re: Conditional Formatting with Named Ranges

    try Formula is $A1="X1"

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,625

    Re: Conditional Formatting with Named Ranges

    Try =$A1="X1"

  5. #5
    Registered User
    Join Date
    03-09-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Conditional Formatting with Named Ranges

    Thanks guys that worked!!

    But it does not extend to all cells in the selected range.

  6. #6
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,625

    Re: Conditional Formatting with Named Ranges

    You just copy and paste special/format to other cells.

  7. #7
    Forum Contributor
    Join Date
    09-23-2008
    Location
    UK
    Posts
    137

    Re: Conditional Formatting with Named Ranges

    use the format painter to copy the conditional formatting

  8. #8
    Registered User
    Join Date
    03-09-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Conditional Formatting with Named Ranges

    Thanks everyone for the prompt help

    Cheers
    Revverend

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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