+ Reply to Thread
Results 1 to 2 of 2

Highlight cell if row is selected?

  1. #1
    Registered User
    Join Date
    01-18-2013
    Location
    Minneapoils, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    15

    Highlight cell if row is selected?

    Hey there, fellow spreadsheeters. I'm back with a fairly simple question. I've seen many questions asking to highlight a ROW when it's selected, but I only want a cell.

    So let's say I've selected any cell in row 3. In that case, I want A3 to be highlighted. 4, A4. 5, A5. And so on...

    Ideally, this would stop at A60, but I could probably force that by tinkering with conditional formatting.

    I've looked at the code for conditionally formatting this and just can't figure it out, which is why after an hour I'm turning to you guys. Any ideas?

    So, in summary: Highlight A(x), where (x) is the row selected. Ideally not a macro so that way the colors and such aren't reset. If possible, stop at row 60.

    Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Highlight cell if row is selected?

    I dont think CF will do this for you, CF works on formulas and functions, and there is no way to ID what cell you have clicked on, using just a formula or function (that I know of, anyway). You said you dont want VBA, but I think that's the only way you will be able to do this
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Highlight Selected Cell When Using FIND
    By smlaff01 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 03-10-2016, 02:53 PM
  2. Highlight the range of selected cell
    By Motilulla in forum Excel General
    Replies: 6
    Last Post: 07-07-2013, 01:51 AM
  3. [SOLVED] Highlight row based on selected cell value
    By elevdown in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2012, 11:28 AM
  4. Highlight the cell based on selected value
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2009, 02:20 AM
  5. How to highlight the selected cell
    By jeffreykeefer in forum Excel General
    Replies: 2
    Last Post: 03-03-2008, 12:33 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